I have 7 different values in the cell "K1" such as AA,BB,CC,DD..etc. If I
select "AA" in cell K1 the color of the cells from A1 to K1 should change to
red. If I select BB in "K1" the color of cells A1-K1 should change to green.
In the similar way for other 5 conditions also.

I am using Excel 2003 and it doest allow me to do this using Conditional
formatting, as it will support only 3 conditions and I have 7 conditions.

Thanks
SR

"Don Guillett" wrote:

More info or do we just need to guess

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Srajes" wrote in message
...
rows

"Don Guillett" wrote:


rows/columns??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Srajes" wrote in message
...
Hi,

I need to change the color of a range of cells depending up on the
value
in
another cell.
Consider cells
1 2 3 4 5
, I need to change the color of all thse 5 cells depending up on the
value
in cell 5.

Thanks in advance for your help.
SR