SOLVED

Conditionally format blank cells

Copper Contributor

How can I conditionally format blank cells? I.e. highlight all the blank cells in a range. Can't find this option on Excel 365 (on a Mac, but I think it doesn't matter for 365).

1 Reply
best response confirmed by SamusAran (Copper Contributor)
Solution

@SamusAran 

As a variant you may select your range and apply to it the rule with the formula

=ISBLANK(A1)

assuming A1 is the top left cell of your range

 

1 best response

Accepted Solutions
best response confirmed by SamusAran (Copper Contributor)
Solution

@SamusAran 

As a variant you may select your range and apply to it the rule with the formula

=ISBLANK(A1)

assuming A1 is the top left cell of your range

 

View solution in original post