How to avoid printing of highlighted cell in Microsoft Excel

[Culpritism]

I want to highlight some cells to flag me to fill those in. Is there a way to show the highlighted part on the screen but NOT when it is printed.

[-Deven-]

You can do that by enabling draft mode or just black and white print. You can also highlight the cell with different colors if you are enabling the settings of Black and White printing. Click on File > page setup > sheet check the B&W box. Then run the print and you can see the print is only black color while excel ignores the colored cell.

[JyotiT]

You can use the code to eliminate the highlight of these cells, print and highlight again

Sub colored()
Range("YOUR RANGE").Select
Selection.Interior.ColorIndex = xlNone
Range("A1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Range("YOUR RANGE").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("A1").Select
End Sub