Sunday, October 16, 2016

yogi_Conditionally Format Rows A:F Where For The Same Week Same Cut Or Add Appear In Columns E and F

Google Spreadsheet   Post  #2077
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question by: danielTurvey:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/zqA64BytPJI;context-place=forum/docs
Conditional Formatting Multiple Conditions Help
Howdy friends!

I'm struggling with conditional formatting and could really use some help.

In the table below I want to highlight rows 2 and 4 because the Week is the same and CODE2 appears in both Rows.

WeekCutAdd
16/12AMINIPRG
26/5CODE1CODE2
36/12AMINIJAM
46/5CODE2UNTY

The goal is to highlight instances where the same course is being add or cut for the same week.

Any help would be greatly appreciated!
 - Dan

Here is a link to the sample data:

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