Permanent conditional color formating

[doriannjeshi]

Hi,
I have large set of data and want to know what is the fastest and lightest way to make a conditional formating colored cell apply permanently. Possible with a macro

 

[Peter_SSs]

Is this really about what you asked here?

If not, give us (preferably with XL2BB Mini Sheet, not Table Only) details about what you have on your worksheet, where it is and explain what you have or want to have Conditionally Formatted and subsequently permanently coloured.

 

[doriannjeshi]

this is about making that conditional formating permanent
And since the formating affects only background color this solution is the fastest I got

Dim r
For Each r In Selection
r.Interior.Color = r.DisplayFormat.Interior.Color
Next r
Selection.FormatConditions.Delete