| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting-different data to one color
I have a column of data that contains codes in the form of letters and
numbers. I would like to use conditional formatting to change the background color of certain codes to one color, for example code A, f, J, 7 etc.( I have about 15 of them) to a background color of red and leave the rest as they are. Is there a formula I can use to do this? Any help would be appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting to color cells | Excel Discussion (Misc queries) | |||
| Conditional Formatting on Color | Excel Worksheet Functions | |||
| Color Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Threaded Mode
