I am updating some paperwork at work. We do a LOT of paperwork and much is still done with a good old pen and paper. However, i am sorting things out so it much easier to avoid mistakes in calculations by forc...er...encouraging my team to use the PC's more . Trouble is, some people are not so PC minded in my work and can make a real mess of things.
Right, i have an account sheet in excel. All the layout and forumlas are sorted. To help people to not change any forumlas, edit the layout or type in the wrong cells, i have 'protected' the workbook and have locked all cells on the page, apart from the ones i want them to type thier figures into.
Now what i really want to do it highlight all the cell's they are ment to type stuff into (i.e. in yellow or something) but i don't want the highlighting to show up on the final print out.
I have looked everywhere but can find an option. Any idea's?