Highlight blank cells using Find And Replace - Excel Tips and Tricks

Discover how to highlight blank cells using fine and replace. This will answer a question how do I highlight cell rules for blank? We don't really need to use conditional formatting to highlight blank space. You can use fine and replace.

Here are the steps outline on the video.

Highlight blank cells
1) Select your dataset
2) Ctrl+H
3) In "Replace with", Format...
4) Fill tab
5) Yellow
6) OK
7) Replace All
8) Close