Here is what I want. If a person types "yes" in any of cells A1:A10 then I
want the adjacent cell to the right to change to the value "red".

For example, if they type yes in cell A3 then cell B3 would automatically
change to the value "red".


--
Thanks
Shawn