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