Megan Hagedorn No Comments

Maybe I’m the odd duck here, but up until recently I ignored the “Conditional Formatting” options in Excel.  Boy, was I missing out! Conditional formatting is great, and Excel actually offers some really helpful options.  Below, we will walk through highlighting blank cells in Excel, but I encourage you to check out the other possibilities as well.

First, make sure your data is formatted as a table.  Select the column(s) you want to apply the formatting to, then select the “Conditional formatting” menu item. In this example, we’ll choose “New Rule” below “Icon Sets”:

Select “format only cells that contain”, then choose “Blanks” from the “Format only cells with” dropdown. Set the format for the highlighted cells by selecting the “Format” button:

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *