You can use any of these methods which you think is perfect for you. So these are the three methods that you can use to highlight blank cells.
EXCEL IF THEN FORMULA BLANK CELLS CODE
When you run this code it will check each cell from the range and then apply red color if a cell is blank. Rng.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed And, that’s why we have a macro code to apply color to all the blank cells from a selected range. I know you have unconditional love for VBA. Use a table in your data and conditional formatting will extend when you add new data to the table. It’s a one-time setup, you don’t have to apply it again and again.
In conditional formatting options, select “highlight cell rules” and click ”more rules”.Go to ➤ Home tab ➤ Conditional Formatting.Conditional Formatting to Highlight Blank Cells If you want to use a dynamic method, you apply the conditional method, see the next method. After that, go to the home tab and apply the color to highlight the cells.(It will select all the blank cells from the table.) From Go To Special window, select “Blank” and click OK.Go to Home Tab ➤ Find & Select ➤ Click on “Go To Special”.Below are the steps you need to follow to highlight all the blank cells. This method is simple: Select all the blank cells and apply cell color. If you want to apply color to all the blank cells from a range, go to a special option can be an easy-to-use way. More Tutorials Highlight Blank Cells with GoTo Special