Forum Discussion

Mike Berrisford's avatar
Mike Berrisford
Copper Contributor
Dec 09, 2017

Need help with conditional formatting equation

I am trying to format a cell based on the name in column D if the cells are between the dates shown in column B and C.  For instance in row 14, I would like to have L14 through R14 formatted to a specific color based on the name in D14.  Please help.

 

 

excel

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Dec 13, 2017

    Hi Mike,

     

    If in row 2 your numbers are actual dates formatted with custom format "d" when you may use the rule

    =(L$2>=$B14)*(L$2<=$C14)*($D14="Turner")

    (take care about absolute and relative references) applied to you range, e.g. 

    =$L$14:$W$26

    Such rule shall be repeated for each name (other words color), as many you have them. Sample

     

     

Resources