Formula

Closed
Report
Posts
1
Registration date
Sunday May 15, 2016
Status
Member
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.