Automatically highlight non empty fields or rows in Excel

For example, in the Table below, I have not yet received inputs from Brad Williams, Linda Johnson and Michael Johnson. Instead of going through the list and pulling each name, can the rows be automatically

highlighted if inputs are not there so that I can clearly see the input status?

excel automatically highlight non empty fields or rows

To do it in Excel, here is the answer:

a) Select the entire Table. Under "Home" click on "Conditional Formatting". Click on "New Rule".

excel automatically highlight non empty fields or rows

b) In the "New Formatting Rule" dialog box that pops up, click on "Use a formula to determine which cells to format".

Enter the formula =COUNTBLANK($M3:$W3) in the "Format values where this formula is true:" field.

The argument $M3:$W3 corresponds to the first row. Since for the row number $ sign is not used, checks are performed for each row as rule is applied for the entire range.

excel automatically highlight non empty fields or rows

c) Click on Format. And choose a format to as desired. Click OK. Click OK.

excel automatically highlight non empty fields or rows

d) Rows that have missing data are highlighted as per format chosen as shown below.

excel automatically highlight non empty fields or rows

 

You can find similar Excel Questions and Answer hereunder

1) How can I show summary reports with Totals only hiding all the rows containing the details?

2) How can I get the last non-zero value in a row?

3) Highlight row of selected cell in Excel

4) How can I set non-contiguous print area using VBA?

5) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

6) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

7) How can I remove all nonprintable characters from text?

8) How to hide and unhide rows and columns in excel VBA

9) How to delete rows with Excel VBA

10) How to hide and unhide rows and columns in Excel

 

Here the previous and next chapter