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   Oct-16-2016
question by: danielTurvey:!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.


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: