True story: On Friday (17th April - 2015), I flew from Vizag (my town) to Hyderabad so that I can catch a flight to San Francisco to attend a conference. As I had 10 hours of overlay between the flights in Hyderabad, I checked in to a lounge area so that I can watch some sports, eat food while pretending to do work on my laptop. There was a gentleman sitting in adjacent space doing some work in Excel. As I began to compose few emails, the gentleman in next sitting space asked me what I do for living. Our conversation went like this. Me: I run a software company He: Oh, so you must be good with computers Me: smiles and cringes at the stereotyping He: What is the formula to select all the blank cells in my Excel data and highlight them in Yellow color Mind you, he had no idea that I work in Excel. We were 2 random guys in airport lounge watching sports and eating miserable food. Me: Well, what are you trying to do? He: You see, I am auditing this data. I need to locate all the blank rows and set them in different color so that my staff can fill up missing information. Right now, I am selecting one row at a time and filling the colors. Is there a one step solution to this problem? Needless to say, I showed him how to do it faster, which led to an interesting 3 hours at the lounge. End of true story. So today, let's understand how to find & highlight all the blank cells in the data.