Help editing VBA code

[wonderd]

Hello everyone,

I need help modifying the below code. Currently If the value is Blue in one cell, then it puts the word Color in another cell. How do I add onto the code to make it look for Green and Black also?

So if Blue, Green, or Black then the output is Color

Please Login or Register  to view this content.

Appreciate any help!

[Pango]

Try:

Please Login or Register  to view this content.

[Pango]

Or this:

Please Login or Register  to view this content.