SAVE YOUR WORKBOOK BEFORE DOING THIS TO PRESERVE YOUR CONDITIONAL FORMATTING.
Alt - F11 to open the Visual Basic Environment
From the menu click Insert
From the drop down click Module
Paste this code into the Module that opens
Code:
Option Explicit
Sub RemoveCF()
Dim sht As Integer
Dim response As Integer
response = MsgBox("Be sure to save your workbook before continuing" & (Chr$(13)) & _
"Click YES to continue or NO to Exit this routine", 276, _
"HAVE YOU SAVED YOUR WORKBOOK")
If response = vbNo Then Exit Sub
For sht = 1 To Sheets.Count
Sheets(sht).Cells.FormatConditions.Delete
Next sht
End Sub
close the Visual Basic Environment
Hit Alt - F8
Select the RemoveCF macro and run it
The worksheets can now be printed with all conditional formatting removed from the workbook.
Make sure you DO NOT SAVE the workbook at this point because all the conditional formatting you did have is gone.
Hope this is of some assistance.
Bookmarks