Forum Discussion

DavidG375's avatar
DavidG375
Copper Contributor
Apr 22, 2023

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

 

excel
Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Apr 22, 2023

    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.

     

Resources