Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ltat42a
 
Posts: n/a
Default Shade cell according to text?


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 09:26 PM
Wrapping in Excel (fitting many lines of text in cell to print rig hd3017 Excel Discussion (Misc queries) 3 December 8th 05 02:19 AM
Cell text based on 4 condition test Bob Wall Excel Worksheet Functions 3 November 16th 05 08:34 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 08:10 PM
Moving text from one cell to another. estaban botas Excel Worksheet Functions 1 December 15th 04 03:04 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"