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
|