automotically highlight non empty fields or rows in Excel

Q76. I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

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 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 excel excel automatically highlight non empty fields or rows

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

excel excel excel excel automatically highlight non empty fields or rows

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

excel excel excel excel excel automatically highlight non empty fields or rows

 

You can find similar Excel Questions and Answer hereunder

1) How can I add a Prefix to a set of numbers in a range?

2) Determine if hyperlinks are valid in Excel

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

4) How can I find the number of working days between 2 dates given a holidays list?

5) Autofill a b c d aa ab in Excel

6) How can I quickly navigate to a frequently used field in a voluminous worbook?

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

8) Remove the apostrophe cell text values in Excel

9) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

10) How can I export a chart as a gif file?

11) Import txt file in Excel

12) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

13) Highlight row of selected cell in Excel

14) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

15) Split string into multiple columns in Excel