Change cell colour display rule based on a number value in that field

I know i’m probably missing a some obvious here!

I have a field (Days Until Due) that is an equation based on the number of days between two date, Order Date and Due date. I want to change the background of the cell in the table based on how many days are left until the due date to work like this…

If Days Until Due is greater than 5 then green
If Days Until Due is between 1 and 4 then orange
If Days Until Due is less than zero then red

I’ve tried using both the Days Until Due and the Due Date fields to base the logic but neither give me a between option or any way of saying something like greater than AND less than.

Ive also tried something like this to test it
If Days Until Due = 4 then orange
If Days Until Due = 11 then green
In this case it doesn’t do either

Also im not just typing “green” i’m choosing a #12345 value.

Thank in advance for any guidance

Hi Simon

Here’s what we do for something similar to your scenario, and hope it might help you.


1 Like

Excellent, thank you