Saturday, March 7, 2015

yogi_Conditionally Format Cells In Column C That Are Not In Sheet Ideas Column A

             Google Spreadsheet   Post  #1910
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-07-2015
question by NathnielElliott:!category-topic/docs/spreadsheets/6uDWFpfIYsE
Changing the color of a cell in a column if there is no match.
I have a column (C) that is connected to a google form. If an input does not match one of the following words (100 words) I need it to turn red so that someone can manually update that field if needed. How would I accomplish this?
Thanks for being willing to look at this. Here is the link:

On the tab "receipts" I need to do conditional formatting that shows "red" on any cells in "Sub Category" that don't match with tab "ideas" list of words.