Change background based on value in another column

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 27

Change background based on value in another column

Hi,

I have in column A options: a,b,c or d

depending on what is chosen is it possible change the background color of
the relevant row in B and C?

i.e. if a3 = a then b3 & d3 background is red or
if a3 = b then b3 & d3 background is green etc

If possible is it possible to do this automatically i.e. not run a macro
just on a cell change in A?

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
Can I change background colors based on criteria from another cel.	WavMaster	Excel Discussion (Misc queries)	2	February 8th 09 07:19 PM
change background color based on range value	DanL	New Users to Excel	2	February 6th 09 09:35 PM
Change background color based on value in column A	JT Innovations	Excel Discussion (Misc queries)	4	January 23rd 09 07:14 PM
Change cell background based on multiple cells	[email protected]	Excel Worksheet Functions	2	July 25th 07 05:03 PM
What is the macro to change background based on numeric cell value	Still learning	Excel Worksheet Functions	2	June 21st 06 05:58 PM

All times are GMT +1. The time now is 11:39 AM.

Menu

About Us