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?
To do it in Excel, here is the answer:
a) Select the entire Table. Under "Home" click on "Conditional Formatting". Click on "New Rule".
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.
c) Click on Format. And choose a format to as desired. Click OK. Click OK.
d) Rows that have missing data are highlighted as per format chosen as shown below.