Excel Hacks: How to Quickly Highlight Blank Cells in Large Datasets

[@iKnowledgeSchool]

Get the Excel practice files using this link: app.getresponse.com/site2/86cd55d06bfe5ebfa2788a5c1cfcf34e/?u=QbDuH&webforms_id=zpOLK

[@Rice0987]

Anyway on next step you have to use filter to fill that gaps.

[@iKnowledgeSchool]

Hello, thank you for watching, and you have a valid point. In this case, however, the real inspiration uses this technique to send color-coded missing data to separate teams and help collectively with this task.

[@Rice0987]

@@iKnowledgeSchool Thanks, you are absolutely right. Colorizing helps to see a picture of leakiness of your data. :)