change color of conditional formatting into real colors

[john_cash]

Hi to all.
I have a range of cells with conditional formatting.
Is it possible to remove it and leave the color of the cells?
On the net i found this macro but i can't try it i have excel 2007 and i think it works for excel 2007 higher

Sub remove_color_formatting()

    Dim cell
    
    For Each cell In ActiveWorkbook.ActiveSheet.Range("A5:P15").Cells
        cell.Interior.Color = cell.DisplayFormat.Interior.Color
        cell.FormatConditions.Delete
    Next
    
End Sub

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Please provide links to all sites where you have asked this question.

 

[john_cash]

Sorry for the forum link

https://www.excelforum.com/excel-programming-vba-macros/1382327-transform-conditional-formatting-colors-into-real-colors.htm

 

[john_cash]

Hi to all, can't edit for excel 2007?
Or is there an alternative macro?

 

[Fluff]

Cross-posted yet again without links.
You MUST supply links to EVERY site you ask the question on.

 

[john_cash]

Sorry for the forum link

change macro for excel2007

Hi to all, it's possibile chande this macro for excel2007? Sub fixCF_Formatting() On Error Resume Next Dim CF_range As Range Set CF_range = ActiveSheet.Cells.SpecialCells(xlCellTypeAllFormatConditions) On Error GoTo 0 If Not CF_range Is Nothing Then...

chandoo.org