Conditional Formatting
Condition 1: =B4=1 (Format as green)
Condition 2: =B4=2 (Format as orange)
Condition 3: =B4=3 (Format as red)

No, you can not change tabs color through Conditional Formatting


"mpenkala" wrote:

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