| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting from a list
How do I conditionally format a cell if the data in the cell matches any cell
in a list of 100? For example: Col A Col B bob art jim bob kirk will greg sam I want to format the cells in Col A such that "bob" will fill red with white letters if his name shows up in Col B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting from list on separate sheet | Excel Discussion (Misc queries) | |||
| Conditional formatting - multi-item text list | Excel Worksheet Functions | |||
| using conditional formatting to mark repeated names in list? | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
