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

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

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

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

Thank you so much. This is very helpful!
 

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

Thank you so much. This is very helpful!
 

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