Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
different color for duplicates!!! how?
i have table full of numbers,
what i need is to find duplicates and mark them with different colors. so like one numbers with red color, others with green, other yellow and so on. so each set of duplicates will have own color. i think it will be easier to see if we have this number so i will then delete it from all rows. i just used this formula, but donno how to make scenario above =COUNTIF(L:L;L27)1 thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Duplicates with different Color | Excel Discussion (Misc queries) | |||
Color duplicates | Excel Discussion (Misc queries) | |||
Need to Color Record in Duplicates | Excel Worksheet Functions | |||
Color Code Duplicates | Excel Programming | |||
Can MS EXCEL remove duplicates and separate by color coded items ? | Excel Programming |