If we type some data in the cell C5, the red highlighting will disappear.Īlso, if we delete the value in, for example, the cell B4, Excel will automatically highlight the cell in the colour we’ve chosen. And what’s even better, as you already know, the highlighting will be dynamic. The blank cells in the table have been highlighted in red just as we wanted. So, click on the chosen colour and confirm with OK. We’ll now define that the blank cells will be highlighted in, let’s say, this red.

Here you’ll find various possibilities of how you can format the blank cells. We want to highlight only blank cells, so we’ll go for the option ‘Blanks’ here.Īnd the next step is to specify how Excel should format the blank cells within the table. Specify How Excel Should Format the Blank Cells In the pop-up window, select the option ‘Format only cells that contain’. Go to group ‘Styles’, click on ‘Conditional Formatting’ and select ‘New Rule’. If you’re working with a table that contains a lot of information, just select whole columns. This method provides a great overview of which cells in a table are blank and which contain some data.įirst thing that needs to be done is to mark the area in which we want to have blank cells detected and highlighted. But as soon as you enter a value in this cell, the highlighting will disappear automatically. In other words, if there’s a blank cell in the table you’re working with, it’ll get highlighted. Conditional formatting will ensure that highlighting will be dynamic, which means it will follow any change made in the table. This tutorial provides a detailed description on what to do to highlight blank cells using conditional formatting. At the beginning of this video, I’m gonna do the usual and tell you that there’s more than one way to highlight blank cells in an Excel spreadsheet.

How to remove highlighting in word 97