View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Conditional Formatting?

Hi Hayle,
You could use File, Page Setup, Sheet, Print B&W
which will print all text as black and leave out shading.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Hayle" wrote in message ...
Greetings all,

I have a pread sheet with a number of cells with a light yellow background
intended to signify the user to manually enter data here.

Once completed, the sheets are printed to a document generator, but I would
like to add an option for the user to remove the yellow background.

Is it possible to make the Background of these cells conditional to a check
box or radio button the user can toggle on/off upon completion of the data
entry, or is there another method I should be using?

Thanks for any advice.