Result of IF conditional change cell color

O

Olasin

When a condition is met I would like to change the cell to RED, YELLOW
or GREEN - simple example

if >70 then green

thanks in advance for any ideas...
 
E

Elkar

Use Conditional Formatting.

Select your cell(s) to apply the formatting to.
From the Format Menu, select "Conditional Formatting..."
Select you condition. (In your example, "Greater than" and enter 70)
Then select the format to apply. (In your example, green background.)
Click ADD>>
Select your next condition.
Then select the next format to apply. (YELLOW Background)
Click ADD>>
Select third condition.
Then select third format to apply. (RED Background)
Click OK

That should do it.

HTH,
Elkar
 
Top