Conditional Formatting Row Highlight Question

[Russ At Index]

Hi

I have the following formula in conditional formatting =$F2>0 Sheet1!$A$2:$F$5
and it works at treat , colours my rows that have a value > 0

However , the last row it "colours" is F ( as the formula states) , i have some
22 additional columns after F that i would also want to colour.
Any way of extending the row hight to a determined length ??

TIA

Russ

 

[p45cal]

apply it to
Sheet1!$A$2:$AB$5
instead of
Sheet1!$A$2:$F$5

 

[Russ At Index]

Thanks p45cal ,

Just the Job !!

Russ

 

[lordguharoy]

can someone please tell me how to hilight a entire row with the help of vlookup.i want to extract the cell in which the data is with the help of vlookup and want to hilight the entirewhole row by coloring the particular row.kindly guide me.

 

[p45cal]

Where/what is the value you're looking up?

can someone please tell me how to hilight a entire row with the help of vlookup.i want to extract the cell in which the data is with the help of vlookup and want to hilight the entirewhole row by coloring the particular row.kindly guide me.