Want to find cells with certain fill colors in a range. VBA. Excel 2007.
I can't even use Find & Select to do it. All I get is "Preview" in the
format space and it can't find anything. Even with identifying the cells
contents. Like find 25 with fill color red.

I do "find" 25 format fill red and nothing happens.

Then I try choosing the format from the cell. Same thing. It can't find it.

I was hoping to record it in a mcro and learn from it. Nothing works.

John