VBA if interior color statement

[Pinaceous]

Hi All,

Okay, I find out what I need. How can I create an IF statement that will add text into a cell of Column E in the Range E11:E180, if the interior color of that columns cell becomes red?

For example; if cell E12 has an interior color red that the sub will add "TEXT" into that cell as shown in the picture?

Please let me know.

Thank you,

pinaceous

 

[Michael M]

I'm not sue about 365, but I don't think changes are triggered in a worksheet change event.
Have a read here though, it may help...

Capturing cell color change in VBA

Is there a way to capture a cell color change within an event in VBA? I've tried the worksheet change event, but when just changing the background color it doesn't trigger the event. Is there another event that would do this? Thanks in advance!

www.mrexcel.com

 

[Fluff]

Duplicate to:VBA Red Cell Criteria

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.