Converting conditional color formats with hard colors

[roscoe]

I have a really really really large file with formulas and conditional formats that drive a loooong recalculation cycle (many minutes). I can copy/paste the formulas to values to save some of that time back, but I haven't figured out how to do that with conditional formatted colors (i.e. make the colors "hard" and not conditional).

Ideas?

Thanks!

 

[Rick Rothstein]

I have a really really really large file with formulas and conditional formats that drive a loooong recalculation cycle (many minutes). I can copy/paste the formulas to values to save some of that time back, but I haven't figured out how to do that with conditional formatted colors (i.e. make the colors "hard" and not conditional).

Maybe this macro will do what you want (note - it does not remove the Conditional Format, only colors the cell)...

Sub MakeConditionalColorsFixed()
  Dim Cell As Range
  On Error GoTo NoConditionalFormats
  For Each Cell In Cells.SpecialCells(xlCellTypeAllFormatConditions)
    Cell.Interior.Color = Cell.DisplayFormat.Interior.Color
  Next
NoConditionalFormats:
End Sub