using colours

[Steven]

hi peeps, just wondering how to use fill colour in cells but for the colours
not to be printed?

Thanks,
Steve-

 

[Gord Dibben]

Steve

File>Page Setup>Sheet. Checkmark in "Black and White" and/or "Draft Quality"

Gord Dibben Excel MVP

 

[Steven]

cheers Gord,

oh, what about using colours for formulas? anyway to auto colour cells to
show linking cells?

Many Thanks,
Steve

 

[Dave Peterson]

How about an ugly way?

When you are editting the formula (and can see the precedents), hit
alt-printscreen.

Then paste into your favorite graphics program.

You could also show the audit (or formula auditing) toolbar. Click on the show
precedents and print while the arrows are shown.