Conditional Formatting to Cell Colors

[Maulajatt]

Guys,

I am new to the excel vba and I have been using the Conditional Format to highlight analysis of data. Can someone help me to Convert the Conditional Formatting format to normal Cell formating. For example, If I Use Conditional formatting to highlight yellow the top 10 SAT scorers out of the whole state students. I want those cell to remain yellow even if I remove the conditional formatting. Can someone help me with this

 

[PeteWright]

Just found this code on some site:

Sub removeConditionalFormattingButKeepColors()
    Dim cell As Range
    For Each cell In Selection
        cell.Interior.Color = cell.DisplayFormat.Interior.Color
    Next
    Selection.FormatConditions.Delete
        MsgBox "Done removing conditional formatting rules."
 End Sub

Unfortunately it only works on background color.

What kind of Conditional Formatting do you have (Font type, font size, borders, aso)? I could adjust the code.