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.
Thank you very much for your help
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!
