Forum Discussion
SamusAran
Jul 10, 2019Copper Contributor
Conditionally format blank cells
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).
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 Reply
Sort By
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