OP had a dropdown. I linked to this for a named range table.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < Columns("m").Column Then Exit Sub
Cells(Target.Row, 1).Resize(, 13).Interior.ColorIndex = _
Application.VLookup(Target, Range("colorpicks"), 2, 0)
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...

I still don't understand. You can't do what I think you are saying.
If desired, send your file to my address below along with this msg
and a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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