Hello,
I have a range of cells, lets say A2:A22.
The rows are banded (alternately coloured) by way of 'format cell' (no table or conditional formatting).
The user is expected to enter information into these cells.
Sometimes, to save time, the user will copy or cut a cell and paste it elsewhere (e.g. copy A5 and post it to A6).
The information is pasted successfully but so too is the shading, which means the alternate pattern no longer exists.
I feel I have tried all combinations of locking and protection, but cannot find a solution to 'lock' the cell shade.
Assistance in this matter would be incredible.
I thank you.
-B-
Bookmarks