Conditional Formating - Hiding actual values

  • Thread starter Thread starter andreww
  • Start date Start date
A

andreww

Hi - I have a series of cells which have number in them. I add conditional
formats so that if the value in the cell is above certain thresholds the
cell is coloured red/amber/green (traffic light repoprts). The thing is when
the report is printed the numbers still show.

Anyone got any ideas as to how I can "blot" out the numbers so they don't
show??

I have tried colouring the numbers white/transparrent, adding conditional
formats the the font (or something similar)!!

Cheers

Andrew
 
Have you applied the same conditional format colour to the text as the cell?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Using XP default color palette, and HP2210 printer, I have no problem hiding
the number within the cell when matching the font color to the pattern
color.

Screen *and* printout both hide the number.

Have you tried using other printers?
When was the last time you calibrated your printer?
Perhaps check for recent driver updates, revisions.
 
Back
Top