| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that would highlight two identical cells..
Hi..,
I have a lengthy list of cells with numbers within them (say A1:A500) and wish to have a formula which would instantly detect if any of the cells contains the same number (duplicate). Ideally the formula would return a €˜Duplicate Number message within a specified cell (say C1) and if possible highlighting both of the duplicated cells in a different colour. Thanks in advance, Monk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How can I get excel to ignore formula in dependant cells... | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
