Is it possible to use ‘Display Rules’ to change the column/row colour if the date has passed. I have a submission deadline and I’d like it to turn amber if within 2 weeks, then red if the date has passed.
Any help is appreciate! Thank you 
Hi @AnthonyF - I posted this on another thread about a year ago, which should answer your question.
Code:
Hi Carl,
This is great thank you - I wonder if you can help with another issue. I need the column result to turn red if the ‘Submission Date’ is today or has passed. Currently, it shows red all the time.
These are the options I have selected currently.
As a no coder 
, I’m afraid I can’t help further. As you’ll have seen from the video I had permission to produce the short tutorial. Hopefully a coder will be able to assist.
Tagging two active forum participants and very capable colleagues to see if they can help you. @StephenChapman @KnackPros
Cheers Stephen 
or Ian 
if you’re able to help @AnthonyF further 
No code required @CarlHolmes @AnthonyF !
Your display rules can be set up like so:
EDIT: Fixed incorrect date field.
Here is the result:
1 Like
Hi Stephen,
Thank you for your response, unfortunately, I don’t seem to be getting the same outcome as you. I’ve included some photos below:
Currently the Submission Deadline is 08/11/2023 & Complaint Date is 28/10/2023. Seems to work if it’s the same day, but not following week, etc.
Oh my mistake! I chose the wrong field in my example image. My Start Date and your Complaint Date should just be the Finish Date field again (i.e. Finish Date is after today).
1 Like