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

Copper Contributor

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

Screenshot 2023-04-21 170840.jpg


1 Reply


You can try this rule and "applies to" range.


This is the rule for conditional formatting in the example.


This is the "applies to" range.

date formatting.JPG