Hello again to all excel gurus,
As promised, there is a part two for another 500 points.
I plan to build a calendar similar to the attached worksheet and want to be able to use conditional formatting that will use a few different conditions. Where I need the help most is in condition3.
Cond1: Highligh Date if First Shift occurs
Cond2: Highligh Date if Second Shift occurs
Cond3: Highlight From Date where duplicate Shift occurs . (How to setup Conditon where it will turn red when a dupshift occurs, and will let other days color update as well?)