I'm not sure what your purpose is behind "marking" the cells, however i
it is just to let your users know where they have to fill in, you ca
probably best do that by unlocking the fillin cells, then protectin
your worksheet so that only those cells can be chosen. If you do that
then the Tab key will take them from the first cell to the next, to th
next, etc.
If you click on the first cell that you want your users to fill in
then hold down the Ctrl key and click the others, this will select al
of the cells that you want your users to fill in.
Next, go to Format...Cells and click on the Protection tab. Remove th
check from beside Locked. Click OK.
Finally, go to Tools...Protection...Protect Sheet and assign
password. If you have XP or 2003 (if I remember correctly), you ca
also tell the program to only allow the user to select the unlocke
cells. This will cause the Tab key to work for you.
Doing this will keep the user in the right place, but will keep yo
from having to change your print settings each time you want to prin
the sheet.
If, however, you are just shading or coloring the cells for appearance
then refer to above.
Another option would be to use Conditional Formatting. Click the cell
(using your Ctrl key) that you want colored. Then go t
Format...Conditional Formatting. Set Cell Value "is equal to" and typ
some cell address that will always be blank....using the followin
convention:
=$cc$1000
Then click the Format button and click the Pattern tab...and choose th
color. Click OK. The cell will have the color as long as it is blank
As soon as the user puts anything in the cell, the color will disappea
(after they move from the cell).
I hope this helps you
