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...
Formatting
Formulas & Functions
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

 

  • null null's avatar
    null null
    Copper Contributor
    Mar 19, 2018
    That helps so much! Thanks!

Resources