Hi,

You have 2 choices. You manually select the cells in each sheet and clear
any fill colours or put up with a macro which isn't difficult or intrusive.
If you go with the macro idea do this

Alt +F11 to open Vb editor. Double click 'This workbook' and paste this in
on the right. It won't clear conditional format colouring

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.UsedRange.Interior.ColorIndex = xlNone
Next
End Sub

Mike

"Graciegirl" wrote:

Do I have to create a macro if I want all color filled cells to be unfilled
upon saving? I don't want to create a macro.
--
Gracie