question

Cody-2478 avatar image
0 Votes"
Cody-2478 asked YiLu-MSFT commented

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

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].


135579-image.png


office-sharepoint-onlinesharepoint-devoffice-sharepoint-server-customization
image.png (6.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered YiLu-MSFT commented

Hi @Cody-2478 , 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:
135760-75.png

135831-76.png

Result:

135818-77.png


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.


75.png (16.1 KiB)
76.png (11.1 KiB)
77.png (12.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Cody-2478
Have you checked Elsie's answer above? Is there any progress on this thread? Please feel free to reply.

0 Votes 0 ·