| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format color change
I'm not familiar, yet, with a change_Interior_Color Event and I don't know
how your " cell color changes" ? However, one way is to run a loop on all your 180 cells check their Interior Color and change it as requested. This can be easily done by a WorkSheet_SelectionChange event macro which will "fire" when a different cell is selected. Micky "SoggyCashew" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format color change
You can use conditional formatting to change the format based on the value of
a cell, not on the format of a cell. for example: if B1=7 then change font color to black - doable if the background color of B1 = Color 36 then change font color to black - can't do "SoggyCashew" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
