Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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= "Text" Blue/White= "AL" Green/White= "SL" Orange/Black= "ST" 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: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=497629 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions |