Event Change on colour index

G

Graham Haughs

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy rows with Interior Colour Index values 15 and 35 to a new she 7
Macro to change cell colour based on words 3
Worksheet Change event problem 4
Cell Shading Colour Property 8
Colour Index 4
Autocomplete not triggering worksheet change 7
Can't Change Font Colour 3
Selecting all cells of a certain fill (interior) colour (macro?) 4

Top