fill a color to a row
Sorry - I missed out the formatting bit itself
Select format and chose fill. What you can do to enhance it if you don't
want the 1 to be visible is to format font the same colour as the fill.
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"Russell Dawson" wrote:
Conditional formatting - new rule - use formula to determine which cells to
format -
Formula is =$H$6=1
Applies to =$A$6:$J$6
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"mns" wrote:
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
|