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

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -