Jul 10 2019 03:09 PM
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).
Jul 10 2019 03:14 PM
SolutionAs 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
Jul 10 2019 03:14 PM
SolutionAs 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