I really need a SelectionChange event where if any of the cells from O12
to O156 changes to the interior colour index 35 then the text value
"Low" will appear in the relevant cell. I appreciate I need to loop but
if I change O12 to "Low" then it is important that if any of the other
cells change to index 35 that it has no effect on O12 and so on down the
column. The value of O12 may be changed manually to another value but no
event should be triggered while the interior colour stays the same.
I have searched various posts but just cannot seem to get anything to
fit the criteria.

Kind Regards
Graham Haughs
Turriff, Scotland