Lock Conditional Formatting

  • Thread starter Thread starter Matt Colon
  • Start date Start date
M

Matt Colon

Good afternoon,

Is there a way that I may lock the conditional formatting of a cell without
locking out the ability to enter data into the cell? I have several columns
of data, each column with a different conditional formatting scheme. I want
to make sure that no one accidentally copies a cell in one row into another
row or does "fill right/left" - which kills the formatting. When I protect
the worksheet, which disables a user from having access to the formating
buttons (text color, pattern, border), a user can still copy or fill the
format of one cell to another. Any suggestions as to what I can do? Any
help or direction is greatly appreciated.

Regards,

Matt Colon
 
I go round and round with things similar to this every day. I don't know
the answer to your specific problem, but I have found on occasion that a
good "reset" feature can save the day..... say in your case something
that can copy the proper formats over from a secret area to the area of
concern, like maybe a Change-event macro?

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top