See but not print cell color background

[pilot]

Is there a way in Excel2002 to color the background of selected cells but make them print without the color? I'd like to do this without a lot of VBA manipulation, like setting the print property of the colored background to No.

 

[klb]

Have you tried changing the print settings to only print in black and white?

 

[pilot]

It's the simplest methods I love the best. Works like a charm, thanks klb.

 

[Yogi Anand]

Good call klb ...

Regards!

Yogi