Forum Discussion
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...
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
That helps so much! Thanks!
