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
|