| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hi, i need a way to use conditional formatting or another way to highlight
cells based on duplicate names group. Ex: 1 john 2 john 3 john 4 mary 5 mary 6 jim 7 cris 8 cris 9 cris I need all cells with john to be highlighted with one colour, the next group (mary) with another color, the next group (jim) with another color....and so on. All names will be ascending. Can this be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
