Not print Shading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am designing a spreadsheet for recording an employee's flexi time during a
given month which will be printed and submitted to the payroll department.

I have put in validation rules and have protected cells so employees cannot
change the formulas etc I have in place.

What I wish to be able to do is to highlight the cells that the employee has
to complete so they are visible on screen but when the form is printed the
highlights are removed.

Thanks in advance for any help in this matter.
 
Hi Chris,
Here is a simple workaround.
On Sheet2 in cell A1 enter =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)
Copy this down and across to capture all relevant data.
Print Sheet2 rather than Sheet1.
Simple way to do this is record a macro to print Sheet2 and on Sheet1 put a
button that calls the printing macro
- can give more details if needed.
Bernard
 
Back
Top