Changing color of a range of cells dending up on a value in anothr

[Srajes]

Hi,

I need to change the color of a range of cell, depending up on the value in
another cell. I am using Excel 2003. And it allows me to give only 3
conditions when using conditional format. But I have 7 differnt conditions.

Thanks in advance for any help.
Srajes.

 

[AltaEgo]

Unless you move to XL2007, you will need to use VBA. Here are some sites
that will help

http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

http://www.mvps.org/dmcritchie/excel/condfmt.htm


Alternatively, there is an add-in here
http://www.xldynamic.com/source/xld.CFPlus.Download.html