get the color coding in conditional formatting using VBA code

[ammupriyaa]

Hi ,
How can we get the color coding in conditional formatting using VBA code.

Thanks
Amutha

[StevenM]

I wrote this for someone else, but maybe it will help you.
You can play around with the following code, if you're interested.
You will need to change the line:

Please Login or Register  to view this content.

So that it points to a range with format conditions.

The function: GetFormatConditions takes a range (at least one cell) with format condition;
And returns in a string three items: Formula1, Interior.Color, and Font.Color.

Please Login or Register  to view this content.