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.

"luvgreen" wrote:

Thank you so much. This is very helpful!

"Mike H" wrote:

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
"luvgreen" wrote:

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!!