CODEWITHSUNDEEP
excelexcel-formularowconditional-formatting
G_Man97
G_Man97

Reputation: 37

Highlight alternative rows but not blanks?

I am using the following formula in a conditional format in order to highlight every other row on my spreadsheet:

=MOD(ROW(),2)=0

This works fine, however it highlights all rows whether blank or not. I don't want to highlight blank rows.

Please could someone show me how to do this?

Upvotes: 0

Views: 2993

Answers (1)

pnuts
pnuts

Reputation: 59495

Select the range to apply the formatting to, starting at Row1 and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::

=AND(ISEVEN(ROW()),A1<>"")

Format..., select choice of formatting, OK, OK.

This assumes you want to skip formatting a row if just the ColumnA cell in it is blank.

An alternative would be to stick with what you have but add another rule, giving it priority, just to test if the ColumnA cell is blank and then set "no formatting" for that.

Upvotes: 1

Related Questions