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).
View best response
As a variant you may select your range and apply to it the rule with the formula
assuming A1 is the top left cell of your range