Sharepoint Lists - Change background color when the date comes after another date in a differnt column

Question

I have been fighting this for days and can't find the solution. I am trying to compare two date columns. If the date comes before the other column it will show green. If it comes after that other column then it will show yellow. I am basically comparing two different column dates and depending on where the date falls it formats the background accordingly. Can someone please help? This determines whether or not I use this as a tool. So far, I can only get it to show a single color no matter the date in the column I am comparing it to.

In the example shown I am trying to compare the right column to the left. If it comes before or the same day to the left column then it should be green. If it is after, then yellow. Left column [Tech Package Draft Target] Right column [Tech Package Draft Actual].

Answer 1

Hi @Cody , welcome to Q&A forum!

There is a workaround, you can try it and let's know the result.

First, create a calculated column named Status and use a simple judgment formula:

=IF([Tech Package Draft Actual]<[Tech Package Draft Target],"Green","Yellow")  

Then create two conditional rules:

Result:

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.