How did the red color get in the cell... manually colored or conditionally
formatted?

--
Rick (MVP - Excel)


"John" wrote in message
...
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