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     www.energyefficientbuild.com.   Mar-07-2015
question by NathnielElliott:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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: https://docs.google.com/spreadsheets/d/1G6YdNK0nyhv9zrihkmdhsD4Sp5w45g1rd_9tx4EMzZ0/edit?usp=sharing

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. 
-----------------------------------------------------------------------------------------------------------------------------------