| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format color change
Hello, I wanted to use conditional formatting and need help with the formula.
I have a range of cells B1:CM2 that are green Color 10 with a white font. I want if the cell color changes to light yellow Color 36 then the font would be black and if the color changed to white then it would change back to green Color 10 with a white font. How can I do this? -- Thanks, Chad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| change color of entire row by use conditional format | Excel Worksheet Functions | |||
| How do you use conditional format to change a bar color on a char. | Charts and Charting in Excel | |||
| Conditional Format: Expired dates wanting cell to change color | Excel Discussion (Misc queries) | |||
Threaded Mode
