Conditional Formatting with IF function
Hey all,
I'm having some trouble with combining the IF function with conditional
formation. I have a cell(B4) that is a CountA function and returns a number
between 1 and 10. I would like another cell(B1) to change color based on the
number shown in cell B4.
If B4=1, then B1 needs to be green, If B4=2, then B1 needs to be orange, If
B4=3, then B1 needs to be red.
Also - is it possible to change the color of tabs with conditional
formatting?? Just curious.
Thanks again,
Matt
|