excel - Highlight alternative rows but not blanks? -
i using following formula in conditional format in order highlight every other row on spreadsheet:
=mod(row(),2)=0
this works fine, highlights rows whether blank or not. don't want highlight blank rows.
please show me how this?
select range apply formatting to, starting @ row1 , home > styles - conditional formatting, new rule..., use formula determine cells format , format values formula true::
=and(iseven(row()),a1<>"")
format..., select choice of formatting, ok, ok.
this assumes want skip formatting row if columna cell in blank.
an alternative stick have add rule, giving priority, test if columna cell blank , set "no formatting" that.
Comments
Post a Comment