Conditional format changes can not be detected automatically.
The usual automated solution is to watch manually changed cells that trigger the conditional format.
Post a short example file to get the best help as there are several considerations here.




Reply With Quote