Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't print cell colors, Print font colors.
I have made cell colors yellow, to denote input data cells. I then want to
print the worksheet in color without printing the yellow background of the cells. Any suggestions?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't print cell colors, Print font colors.
Before printing, remove the Yellow background from those cells then put it back
after printing. You could address this by recording a macro whilst doing this. Gord Dibben MS Excel MVP On Tue, 12 Feb 2008 10:28:05 -0800, klhetrick wrote: I have made cell colors yellow, to denote input data cells. I then want to print the worksheet in color without printing the yellow background of the cells. Any suggestions?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't print cell colors, Print font colors.
I didn't really want to remove and put back the cell colors. I have multiple
sheets and areas to do this in. Thank you for your input. "Gord Dibben" wrote: Before printing, remove the Yellow background from those cells then put it back after printing. You could address this by recording a macro whilst doing this. Gord Dibben MS Excel MVP On Tue, 12 Feb 2008 10:28:05 -0800, klhetrick wrote: I have made cell colors yellow, to denote input data cells. I then want to print the worksheet in color without printing the yellow background of the cells. Any suggestions?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't print cell colors, Print font colors.
You won't get Excel to print only some colors and not others when you go to
FilePage SetupSheet. You get two choices..........print in color or print in black and white. Can you come up with something else to denote the input cells? FormatCellsPatternsPattern6.25% gray. Or....................... Maybe protect the worksheet and allow users to select unlocked cells only and do away with the color. Gord On Tue, 12 Feb 2008 11:57:00 -0800, klhetrick wrote: I didn't really want to remove and put back the cell colors. I have multiple sheets and areas to do this in. Thank you for your input. "Gord Dibben" wrote: Before printing, remove the Yellow background from those cells then put it back after printing. You could address this by recording a macro whilst doing this. Gord Dibben MS Excel MVP On Tue, 12 Feb 2008 10:28:05 -0800, klhetrick wrote: I have made cell colors yellow, to denote input data cells. I then want to print the worksheet in color without printing the yellow background of the cells. Any suggestions?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't print cell colors, Print font colors.
I give these suggestions a shot. Thanks again for your input.
"Gord Dibben" wrote: You won't get Excel to print only some colors and not others when you go to FilePage SetupSheet. You get two choices..........print in color or print in black and white. Can you come up with something else to denote the input cells? FormatCellsPatternsPattern6.25% gray. Or....................... Maybe protect the worksheet and allow users to select unlocked cells only and do away with the color. Gord On Tue, 12 Feb 2008 11:57:00 -0800, klhetrick wrote: I didn't really want to remove and put back the cell colors. I have multiple sheets and areas to do this in. Thank you for your input. "Gord Dibben" wrote: Before printing, remove the Yellow background from those cells then put it back after printing. You could address this by recording a macro whilst doing this. Gord Dibben MS Excel MVP On Tue, 12 Feb 2008 10:28:05 -0800, klhetrick wrote: I have made cell colors yellow, to denote input data cells. I then want to print the worksheet in color without printing the yellow background of the cells. Any suggestions?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
How can I get excel to print mulitiple colors in a cell? | Excel Discussion (Misc queries) | |||
Why do the Excel cell colors only display in print preview? | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Want colors on screen, but not when print | Excel Discussion (Misc queries) |