Excel: Make conditional formatting static
- by Martin
Is there any way to convert conditional formatting to static formatting in Excel?
I'm trying to export a range of a Excel Sheet to a new Workbook, with identical appearance but no formulas, links, etc. The problem here is that I have conditional formatting that relies on calculations outside exported range.
I've tried saving the workbook to…