Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bluejay
 
Posts: n/a
Default cell color

In EXCEL, I want to change the cell color to reflect the text value. Like if
the cell contains "John", I want the cell color to be green, if "Bob", the
cell color to be Blue, if "Frank", purple, if "Joe", red, etc. I want to be
able to display about 18 different colors. Conditional Formatting has a
limitation of three if conditions. Thanks for your help.
 
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
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
How bring a color on cell from one sheet to another jmor45 Excel Discussion (Misc queries) 0 April 7th 05 09:41 PM
Current Cell Color mike47338 Excel Worksheet Functions 5 December 10th 04 06:45 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"