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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
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.
 
Back
Top