Sunday, February 14, 2016

yogi_Conditionally Format Cells A1:B1 -- Color Yellow if there is a match with entries in C:C otherwise Color Red

Google Spreadsheet   Post  #2036
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-13-2016
post by: Ethan Lloyd:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/EcDgP0mHd_Y;context-place=forum/docs
Conditionally Formatting based on the occurrence of multiple words
I have a cell with a day of the week in it. I want to check(to conditionally format) if that matches any of the days I have in a separate list.

Eg
Cell A1 - Tuesday
Cell B2 - Wednesday


List (C1:C3)
Monday 
Wednesday
Friday

So with this example, A1 should be a different colour to B1
------------------------------------------------------------------------------------------------