SOLVED
Home

Conditionally format blank cells

%3CLINGO-SUB%20id%3D%22lingo-sub-749008%22%20slang%3D%22en-US%22%3EConditionally%20format%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749008%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20conditionally%20format%20blank%20cells%3F%20I.e.%20highlight%20all%20the%20blank%20cells%20in%20a%20range.%20Can't%20find%20this%20option%20on%20Excel%20365%20(on%20a%20Mac%2C%20but%20I%20think%20it%20doesn't%20matter%20for%20365).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749024%22%20slang%3D%22en-US%22%3ERe%3A%20Conditionally%20format%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374449%22%20target%3D%22_blank%22%3E%40SamusAran%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20a%20variant%20you%20may%20select%20your%20range%20and%20apply%20to%20it%20the%20rule%20with%20the%20formula%3C%2FP%3E%0A%3CPRE%3E%3DISBLANK(A1)%3C%2FPRE%3E%0A%3CP%3Eassuming%20A1%20is%20the%20top%20left%20cell%20of%20your%20range%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
SamusAran
Occasional Visitor

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
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

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies