Hi Joanne,
In file, page setup, sheet
[x] Print B&W (black and white)
would probably work.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> Using conditional formatting, can I cause the greenbar to be for
> screen only, allowing printing to be without any greenbar or pattern
> formatting?
>
> Thanks for you help
> Joanne