Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Conditional Formatting "Duplicate Values"

529 views
Skip to first unread message

jor...@officeformac.com

unread,
Jun 6, 2010, 2:45:29 AM6/6/10
to
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am using Excel to enter pipe numbers, on my PC I can use duplicate values to highlight the cell if a duplicate value is entered. Unfortunately I have not been able to figure out how to do this in EXCEL 2008 on my MAC.

John_McGhie_[MVP]@officeformac.com

unread,
Jun 6, 2010, 8:18:54 AM6/6/10
to
Not enough detail to answer.

Basically, you do it the same in Excel 2008 as you do on the PC. Search for
"duplicate" in the Excel Help and it shows two techniques.

Give me more detail on what you need and we can be more help.


On 6/06/10 12:45 PM, in article 59bb9...@webcrossing.JaKIaxP2ac0,
"jor...@officeformac.com" <jor...@officeformac.com> wrote:

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:jo...@mcghie.name


jor...@officeformac.com

unread,
Jun 6, 2010, 5:48:37 PM6/6/10
to
Let me try this again
I use excel to manage pipe ID numbers.
These numbers are received from 6 separate pipe yards.
I have all ID numbers in a column where I want to identify if I have entered a duplicate value/ID number by using conditional formatting highlighted cell rule, duplicate values.
In Excel 2008 under conditional formatting there is no selection for Highlighted Cell Rules, Duplicate Values. There is equal to, greater than, less than etc.
I would like to know if there is a way to identify (highlighted cell) if I enter a duplicate value by having Excel identify this and warn me I already have this value in this column.
On my PC I have Excel 2007 which has the option to select duplicate values. If this is possible in Excel 2008 please advise how to do it because I can not find it.
Thank You for your reply

> Not enough detail to answer.
>
> Basically, you do it the same in Excel 2008 as you do on the PC. Search for
> "duplicate" in the Excel Help and it shows two techniques.
>
> Give me more detail on what you need and we can be more help.
>
>
> On 6/06/10 12:45 PM, in article 59bb9...@webcrossing.JaKIaxP2ac0,
0 new messages