non printable theme color for cell; marking cell requires mandatory updates

[LanaDallas]

I have a spreadsheet which needs to be updated on regular basis. I wanna mark the cell requires mandatory updates with colors but I don't want those to be print. How to add non printable theme color for cell in excel? What is the best way to do it? Please help

 

[mrshl9898]

You could copy the sheets format to another sheet, make it blank, print, then copy them back.

Sub Macro1()


    Sheets("Sheet1").Cells.Copy
    Sheets("Sheet2").Cells.PasteSpecial Paste:=xlPasteFormats
    With Sheets("Sheet1").Cells.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    Sheets("Sheet1").[COLOR=#000000][FONT=Consolas]PrintOut[/FONT][/COLOR]
    Sheets("Sheet2").Cells.Copy
    Sheets("Sheet1").Cells.PasteSpecial Paste:=xlPasteFormats


End Sub