Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting same numbers?
I have a range A2:A125, that numbers are entered into, how do i set the
conditional formatting for all these cells so that if any of the numbers are the same (if they are duplicated in any of these cells) they highlight in a different colour. red for instance. is there a formula i can enter? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting same numbers?
=COUNTIF(A:A,A1)1
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jackrobyn1" wrote in message ... I have a range A2:A125, that numbers are entered into, how do i set the conditional formatting for all these cells so that if any of the numbers are the same (if they are duplicated in any of these cells) they highlight in a different colour. red for instance. is there a formula i can enter? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting cells beginning with certain numbers | Excel Worksheet Functions | |||
Highlighting the 5 Largest Numbers in a list | Excel Discussion (Misc queries) | |||
sum won't show when highlighting a series of numbers | Setting up and Configuration of Excel | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
highlighting cells when reaching certain numbers | Excel Discussion (Misc queries) |