Apr 21 2023 05:45 PM
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
Apr 22 2023 12:15 AM
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.