Result of IF conditional change cell color

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...

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


"Olasin" wrote:

>
> 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...
>
>
> --
> Olasin
> ------------------------------------------------------------------------
> Olasin's Profile: http://www.excelforum.com/member.php...o&userid=34502
> View this thread: http://www.excelforum.com/showthread...hreadid=542693
>
>