Conditional Formatting

Roshni Verappan

HI

I am trying to use Conditional formatting to highlight when an Expiry Date is in the next 45 Days, 50 day and 60 Days and have them all different colours.

i.e. 45 Days would be Red and 55 Days would be Yellow etc...

Any help would be appreciated.

thanks

Andrée Starå

Hi @roshni verappan

I hope you're well and safe!

Add a so-called helper column. You can call it, Days left. You'd then add three different Conditional Formatting rules.

Try something like this.

=[Expiry Date]@row - TODAY()

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!