Prev: Pass Command Button info
Next: freeze panel in a userform spreadsheet
From: John on 5 Feb 2010 21:46
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

From: Rick Rothstein on 5 Feb 2010 22:06
How did the red color get in the cell... manually colored or conditionally
formatted?

--
Rick (MVP - Excel)


"John" <john6528(a)comcast.com> wrote in message
news:%23BoAlatpKHA.1672(a)TK2MSFTNGP04.phx.gbl...
> 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
>

From: John on 5 Feb 2010 23:22
In a macro

MyCell.Interior.ColorIndex = one of Red, Blue, Yellow, Cleared
Red = 3: Blue = 5: Yellow = 6: Green = 4: Cleared = -4142
MyCell as range.

Don't remember where I got those numbers for the colors. Seem to come up
with pretty much the correct color.

John







Rick Rothstein wrote:
> How did the red color get in the cell... manually colored or
> conditionally formatted?
>
 | 
Pages: 1
Prev: Pass Command Button info
Next: freeze panel in a userform spreadsheet