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.

	Week	Cut	Add
1	6/12	AMIN	IPRG
2	6/5	CODE1	CODE2
3	6/12	AMIN	IJAM
4	6/5	CODE2	UNTY

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:

https://docs.google.com/spreadsheets/d/1rkrysd9n5tt7pKW0A8aEjCchEE5az3Y4bm6JEcnIyjY/edit?usp=sharing

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