Highlight blank cells using conditional formatting in Excel

For highlighting blank cells in excel, we are using conditional formatting. Steps are :

Sample

Step 1 (Open more rules of conditional formatting)

Select data range > Conditional Formatting > Highlight Cell Rules > More Rules

Step 2 (Selecting Blanks from dropdown)

Select : Format only cells that contain > Select Blanks as shown below :

Step 3 (Selecting Style)

Click format > Select Fill Tab > choose color > press ok > press ok in main window

All done…..

Share

You may also like...