Hi
i have a small problem.I am trying to do a conditional formatting that shade alternate rows only if a value (any value) is present in a row.if row is blank then no formatting is applied to that row. the formula that i have is
=AND(MOD(ROW(),2),COUNTA($A$20:$H$37))
The problem that i have with this formula is that as soon as I put any value in any cell in the range the whole range gets the shading regardless of being a blank cell.
any help or suggestion is greatly appreciated.
i have a small problem.I am trying to do a conditional formatting that shade alternate rows only if a value (any value) is present in a row.if row is blank then no formatting is applied to that row. the formula that i have is
=AND(MOD(ROW(),2),COUNTA($A$20:$H$37))
The problem that i have with this formula is that as soon as I put any value in any cell in the range the whole range gets the shading regardless of being a blank cell.
any help or suggestion is greatly appreciated.
