Formula [Closed]

Registration date
Sunday May 15, 2016
Last seen
May 15, 2016
I have multiple rows and one field is called product and the other is color. I am trying to figure out one formula that can be used on all the cells.

ex. Product could say 12" Red Stick or Blue Towel.
There are multiple colors used: red blue green and yellow.

The formula needs to be able to be used in every cell and if it has one of these colors to show it in the cell. Basically if it says red the cell needs to say red.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!