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
|