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

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.

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

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

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

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


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

"Srajes" wrote in message
...
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.