To do something when a cell is this or that (i.e. a cell is equal to "x", "y", etc.) you can use the IF function together with the OR function to run a test. In cell D6, the formula is: =IF(OR(B6="red",B6="green"),"x","") which returns "x" when B6 contains "red" or "green", and an empty string ("") if not. Notice the OR function is not case-sensitive.