I have a column "g" with this conditional formatting:-
=A2<>A3 Format Bottom Border.
However I will pass this workbook onto someone else who will fill in the text in column "g". They will use copy/paste text from other cells or columns even other workbooks that will not have the conditional formatting.
I have used Cells > Projection > Locked unchecked then used Tools > Protection > Protect Sheet and checked all. There does not seem to be a way to unlock the cell but protect Conditional formatting.
Each time I copy and paste from other non formatted cells it wipes out my formatting.
I want to lock just the Conditional formatting.
Any advice please?
Bookmarks