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

As far as I know, there is no event that is triggered by a change in the
interior color of a cell. What occurs to initially change the color? If
that is done by code, perhaps you can add code to not change the color if a
color already exists. HTH Otto
"Graham Haughs" wrote in message
...
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