Forum Discussion
Excel help: highlight cells along a row (conditional formatting?) based on start/end date columns
Hi there, I'm trying to find an easier way to highlight the dates of an activity, per row, based on the start and end dates in column F/G and highlight all the cells in the date range as per the dat...
You can try this rule and "applies to" range.
=AND(G$2>=$E4,G$2<=$F4)This is the rule for conditional formatting in the example.
=$G$4:$P$14This is the "applies to" range.