Conditional Formatting of Rows in a Range

[fred3]

I want to color shade each row in a range of rows according to values in each row:
IF (AND(Bx="",Hx=1) then shade gray ELSE shade white.

 

[GraH - Guido]

Hi @fred3,
Conditional formatting is easy: it works when the formula used returns true. So... in CF use AND($B2="",$H2=1) , applied to the range you need.

 

[fred3]

So, does one have to enter a particular row formula for each row? That's how this appears. I have too many rows to justify doing that.

 

[GraH - Guido]

Nope! I only enter one formula with relative row references (no "$" before the row references). This is rather basic Excel...