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

------------------------------------------------------------------------------------------------