Excel help: highlight cells along a row (conditional formatting?) based on start/end date columns

[DavidG375]

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 dates in row 2.

Is there a formula and or conditional formatting that can highlight at least the start and end date before in the date range area columns J-AO. Tha

[#2]

@DavidG375 

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$14

This is the "applies to" range.