Thread
:
Change the color of a range of cells
View Single Post
#
7
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
Change the color of a range of cells
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett