| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
compare numbers and mark duplicates
Hello all,
I have a row of 9 cells, which I want to fill with the numbers 1 to 9. Each time I put a number in a cell I want excel to compare all 9 cells in the row. If I type in a number that is already in one of the other 8 cells I want it to light up in red. I tried using "conditional formatting" but I can only compare 2 cells at a time. Does anybody have an idea? Thanks in advance, Lucas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
| converting to numbers | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
