Forum Discussion

null null's avatar
null null
Copper Contributor
Mar 19, 2018

Row Formatting

Good morning 

I would like to reproduce with a formula that row formatting above 

-Red border and pink filling for the that contains yesterday's datas.

-The days of the week to come are in grey.

Thank you very much for your help

 

Formatting
Formulas & Functions

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 19, 2018

    Hi Christina,

     

    You may use conditional formatting creating two rules. Assuming your dates are in column A for the pink formatting the rule will be

    =$A1=(TODAY()-1)

    and for the grey

    =$A1>=TODAY()

    applying both rules to your entire range

     

Resources