Thread
:
fill a color to a row
View Single Post
#
2
March 10th, 2010, 04:35 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
Posts: 607
fill a color to a row
formula =
=$h1=1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"mns" wrote in message
...
Hi,
I want to check a column (lets say H) if there is a 1 value i want excel
to
color the row.
lets say there is a 1 on H6, I want to fill a color to row 6. It can be
full
coloring or if i can i might like to range it to A6:J6
thanx in advance
Don Guillett[_2_]
View Public Profile
View message headers
Find all posts by Don Guillett[_2_]
Find all threads started by Don Guillett[_2_]