Detecting the Interior Color of a Cell

[Cyberdude]

I would like to write VBA code that detects what the current interior colorindex of a cell is. The problem is that I can't detect what it is when it is set by a conditional format. Is there a way to do that? To detect the color I use code like the following:

CurrColor = Selection.Interior.Colorindex
This detects the "permanent" color, but not the color that might be present when set by conditional formatting.:dunno

[Richie(UK)]

Hi C,

Its not quite as simple when looking at CF. However, fortunately somebody has already done a lot of the hard work - have a look at Chip Pearson's site here (http://www.cpearson.com/excel/CFColors.htm).

HTH

[mdmackillop]

or Byundt's KB article here
http://www.vbaexpress.com/kb/getarticle.php?kb_id=190

[Ken Puls]

Now how is it that I never found either of those when I was trying to figure out the same thing? :doh:

Cyberdude, thanks for asking this question. Richie, Malcolm, thanks for answering!

[mdmackillop]

Zack answered it too, but because he's too old and slow, he deleted his late response.:devil:

[Zack Barresse]

Zack answered it too, but because he's too old and slow, he deleted his late response.:devil:
Hey! I resemble that remark! :p

[Ken Puls]

Zack answered it too, but because he's too old and slow, he deleted his late response.:devil:
:rotlaugh:

[Paleo]

Me too, thanks!!


Now how is it that I never found either of those when I was trying to figure out the same thing? :doh:

Cyberdude, thanks for asking this question. Richie, Malcolm, thanks for answering!

[Cyberdude]

Hey, thanx, guys! Super examples and code. :beerchug:

[Paleo]

So Cyberdude,

is it solved? If yes, please, mark it solved by clicking on "Thread Tools" -> "Mark Solved".

Thanks.