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. <br /><br />Here are the steps outline on the video. <br /><br />Highlight blank cells <br />1) Select your dataset <br />2) Ctrl+H <br />3) In "Replace with", Format... <br />4) Fill tab <br />5) Yellow <br />6) OK <br />7) Replace All <br />8) Close <br />
