Setting cell background color based on value

Posted to microsoft.public.excel.programming

Erik[_5_]

external usenet poster

Posts: 1

Setting cell background color based on value

Hi

I am trying to set an array of cells' background colors based on their individual text values. Conditional formatting would normally work, but I have 10 different colors to assign and the built in conditional formatting only allows three conditions. Hoping someone could help me with this little project. Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Conditional Sum Based on Cell Background Color	Thomas M.	Excel Worksheet Functions	7	January 21st 13 11:14 PM
Change background color based on cell content from link	joemc911	Excel Discussion (Misc queries)	0	April 22nd 10 04:52 PM
change the color of cell background based on a result	Rich	Excel Worksheet Functions	2	January 27th 09 07:17 PM
Changing background color based on different cell	djarcadian	Excel Discussion (Misc queries)	3	August 10th 06 10:44 PM
Conditionally setting background color of a cell	Scott Steiner	Excel Discussion (Misc queries)	1	November 20th 05 12:11 PM

All times are GMT +1. The time now is 02:45 PM.

Menu

About Us