How to Highlight Blank Cells in Excel (Conditional Formatting)

Learn how to highlight blank cells in Excel. Thanks to this function, you’ll be able to mark clearly all cells containing no data in a table of any size. This tutorial provides a detailed description on what to do to highlight blank cells using conditional formatting. Conditional formatting will ensure that highlighting will be dynamic, which means it will follow any change made in the table. In other words, if there’s a blank cell in the table you’re working with, it’ll get highlighted. But as soon as you enter a value in this cell, the highlighting will disappear automatically. This method provides a great overview of which cells in a table are blank and which contain some data. Ready to begin?

Don’t miss out a great opportunity to learn more:

How to Use Conditional Formating in Excel

How to Sort and Filter in Excel

How to Remove Blank Rows in Excel - BASIC

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 How to Highlight Blank Cells in Excel
1:36 Specify How Excel Should Format the Blank Cells
2:29 How to Turn the Function Off

================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)

Transcription How to Sort Alphabetically in Excel here

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[Runsheeg]

falling in love with both excel and your tutorial. Thank you.

[ameejoshimaharaj]

Excellent way of sharing knowledge
Thank you 🙏🏼

[CreativeMisc]

Thank you for sharing valuable knowledge

[Wafaa]

Yeah, You are wonderful. Thank you so Much👓🎀🎁

[Frank-n-Sense]

excellent video. clearly explanative. only confusion was at the end. it appears the intended audience of this video is specifically someone with an uncle named bob. anyway, thanks.

[Dronythinggoes]

How can it be remained highlighted even if a value has been typed?

[rogerthedodger]

I want to be able to highlight a blank cell that has a formula. So my simpler second sheet is fed from the first by having a formula (eg =Sheet1!A1), but because there is a formula this does not work even though sheet1 cell A1 has no data. Help please?

[akshaydeshmane]

If value is filled and didnt write description then how to color other cell on another cell