software

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

if gt;70 then green

thanks in advance for any ideas...--
Olasin
------------------------------------------------------------------------
Olasin's Profile: www.excelforum.com/member.php...oamp;userid=34502
View this thread: www.excelforum.com/showthread...hreadid=542693Use Conditional Formatting.

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

That should do it.

HTH,
Elkarquot;Olasinquot; wrote:

gt;
gt; When a condition is met I would like to change the cell to RED, YELLOW
gt; or GREEN - simple example
gt;
gt; if gt;70 then green
gt;
gt; thanks in advance for any ideas...
gt;
gt;
gt; --
gt; Olasin
gt; ------------------------------------------------------------------------
gt; Olasin's Profile: www.excelforum.com/member.php...oamp;userid=34502
gt; View this thread: www.excelforum.com/showthread...hreadid=542693
gt;
gt;