Searching for "no fill" cells

[omiller]

I have been using excel to keep up with my inventory. When the product has been purchased, I "fill" the cell in a blue color. Now that I have thousands of products, it has become tedious searching for an item that has not been filled. Is there any way to only search for items that do not have a "fill" colored background?

 

[Saba Sabaratnam]

You could use Find to do this.

Click on Options button on Find and Replace and select the color / no fill that you want to look for. You may want to restrict search for the cells that that have product information.,

Kind regards

Saba


Kin