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   Feb-13-2016
post by: Ethan Lloyd:!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.

Cell A1 - Tuesday
Cell B2 - Wednesday

List (C1:C3)

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