Conditional formatting for due dates

I have a spreadsheet that I share with my coworkers and we have deadline dates. I would like for the format to turn to red when a task is late and green when a task is on time or 0. Any help would be greatly appreciated!

iPad Pro 11-inch Wi-Fi, Cellular

Posted on Dec 20, 2021 12:37 PM

Similar questions

Conditional cell formatting (due dates) in Mac Numbers Hoping that someone can please help me figure out how to set the conditional cell formatting for a Mac Numbers file. Your help is much appreciated, I've tried searching the forums but am getting a little lost in trying to figure this out. Here is what I'm hoping to accomplish: Column I lists whether the invoice has been paid ("received" or "invoiced") Column H lists the payment due date (based on a formula calculating 30 days from the invoice date) When an invoice is unpaid (Column 1 invoiced), I would like Column H to highlight: Green if within 7 days of the due date Yellow if 0-30 days after the due date Orange if 31-60 days after the due date Red if 61-90 days after the due date Thank you very much for your help, truly appreciated.
3397 1
Conditional Highlighting In Numbers In numbers what is the process for conditional highlighting if say i wanted 7 days before a due date for that cell to change colour and stay that colour till that due date. Then After that due date change another colour and stay that way till it has been changed. eg. Due date 14/7/20. Todays date 7/7/20. The cell would change green today then stay green till the 14. After the 14th would change say red. Then stay red till that due date is changed. Thanks.
638 3

1 reply

Badunit

Level 7

30,336 points

Dec 20, 2021 2:32 PM in response to RussellDevon

Select the column of dates and create the conditional highlighting rules shown above. If you want today to be green vs yellow, change the last one to green.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Conditional formatting for due dates

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up