Change color of cells when printing

[Keith]

I have a worksheet that is basically a form for a user to fill in. Empty cells are highlighted yellow (using conditional formatting). I want the worksheet to print with the empty cells not highlighted. How can I do that?

Thanks,
Keith

 

[Gord Dibben]

Print setup>Sheet to "black and white".


Gord Dibben Excel MVP

 

[Keith]

Thanks,
Keith

Print setup>Sheet to "black and white".


Gord Dibben Excel MVP

 

[Keith]

Thanks,
Keith

Print setup>Sheet to "black and white".


Gord Dibben Excel MVP