software

Using Excel XP -
I have some cells formatted as text. The shading is white, text black.
I also have these set with conditional formatting (3). If I enter
certain text, it is set to shade a certain cell color and text color.

If I remove all the text from the cell, is there a way to shade the
cell red, or am I limited to the 3 conditonal formats??

Here's what I'm looking for -
Cell is:
Red= cell with no text
White/Black= quot;Textquot;
Blue/White= quot;ALquot;
Green/White= quot;SLquot;
Orange/Black= quot;STquot;

I'm looking to set this up with over 300 different cells, and I may
have more text options that would be entered other than listed above.

Thanx.

JF--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: www.excelforum.com/member.php...oamp;userid=24735
View this thread: www.excelforum.com/showthread...hreadid=497629