How to know get the color index for the conditional formatting?

[Guest]

I want to know the color index for the current conditional formatting which
is true. How can I get the current condition color with VBA? I can only get
the real cell interior color and couldn't get the condition formatting color.
Please help. Thanks!!

 

[Guest]

Its not simple,

Vba Look here
http://www.cpearson.com/excel/CFColors.htm

UDF here
http://www.vbaexpress.com/kb/getarticle.php?kb_id=190

Mike

 

[Guest]

Thank you so much. This is very helpful!

Its not simple,

Vba Look here
http://www.cpearson.com/excel/CFColors.htm

UDF here
http://www.vbaexpress.com/kb/getarticle.php?kb_id=190

Mike

 

[Guest]

You can also find a color palette in the VBA help files under
PatternColorIndex Property that gives you the basic 56 colors with their
corresponding indexnumbers.