How to convert conditional formatting into true color using VBA?

[mss90]

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

[Fluff13]

How about

Please Login or Register  to view this content.

[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.

[Fluff13]

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

[mss90]

How about

Please Login or Register  to view this content.

This does not seem to work?

[mss90]

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

[rorya]

Okay thanks, I am using the latest version unfortunately

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.

[mss90]

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.

[sintek]

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

[mss90]

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

[sintek]

Add red snippet below Fluff13 code...

Please Login or Register  to view this content.

[mss90]

Add red snippet below Fluff13 code...

Please Login or Register  to view this content.

Thanks, that worked perfectly!

[sintek]

Glad I could contribute...Tx for unexpected rep +

[Fluff13]

Glad to help & thanks for the feedback.