How to convert conditional formatting into true color using VBA?

Hi,

If I have a table with different colors through conditional formatting, how can I convert the colored cells in this table from conditional color to true color using VBA?

Thanks

How about

Please Login or Register  to view this content.

If your Office version is actually later than the 2007 in your profile, you could also use Fluff's method.

Oops, never thought of that

Originally Posted by Fluff13

How about

Please Login or Register  to view this content.

This does not seem to work?

Originally Posted by rorya

Here's one way - adjust the range in the testit routine as needed:

Please Login or Register  to view this content.

If your Office version is actually later than the 2007 in your profile, you could also use Fluff's method.

Okay thanks, I am using the latest version unfortunately

Originally Posted by rorya

Then I suggest you update your profile. If you are using a version later than 2007, then Fluff's code should work so you'll need to provide more information than just "doesn't seem to work". Although, what I posted should still work, unless you have 64bit Office.

I have updated my profile now, apologies for the inconvenience. I am not sure what to add as the code doesnt make the conditional formatting on the active worksheet into true colors. Nothing seems to change, it just loads for a bit.

Originally Posted by sintek

Are you not perhaps wanting to remove conditional formatted color rule and replace with true color...
i.e. remove the rule and replace...

Yes, in other words I want to remove conditional formatting but to keep the colors

Originally Posted by sintek

Add red snippet below Fluff13 code...

Please Login or Register  to view this content.

Thanks, that worked perfectly!

Glad to help & thanks for the feedback.