ExcelBanter - Protect conditonal formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protect conditonal formatting (https://www.excelbanter.com/excel-discussion-misc-queries/17647-protect-conditonal-formatting.html)

ITGuy

Protect conditonal formatting

How do I keep someone (including myself) from pasting contents to a cell
that, in turn, erases its conditional formatting setup? Thanks!

All times are GMT +1. The time now is 11:56 AM.