SharePoint list conditional formatting stopped working

Question

SharePoint list conditional formatting stopped working

sam daddona 5

I have a Sharepoint list that has a conditional formatting for if a certain date comes up the list color changes in another column and it is not working anymore as it was yesterday

1 answer

Your answer

Answer 1

Yanli Jiang - MSFT 31,666 Microsoft External Staff

Hi @sam daddona ,

Welcome to post there!

Could you please provide more details about this issue so we can test it?

Are there any operations that are accidentally modified to the list?

Did other users meet the same situation?

How about clear your browser cache?

Please try to create a new list and test whether the conditional formatting works.

Thank you!

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-10-18T02:21:32.12+00:00

Hi @sam daddona ,

This issue has idled for a long time, did you get chance to look into my answer? Let me know if you have further questions.

If the answer is helpful, please click "Accept as Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-10-21T09:38:42.3033333+00:00

Hi @sam daddona ,

We have not received a response from you. Anything else we can help, feel free to let us know. We would appreciate it if you would like to share a recent update on your issue.

If the answer is helpful, please click "Accept as Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-10-23T02:29:46.8266667+00:00

Hi @sam daddona ,

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.

If the answer is helpful, please click "Accept as Answer" and kindly upvote it.
Crystal D. Wood 0 Reputation points

2024-10-23T17:59:34.2933333+00:00

I'm also experiencing this same issue. OOTB Conditional Formatting of dates isn't working. TODAY is 10/23/2024. I don't fully understand JSON, but it appears that the "Scheduled" date is RED (which is wrong) because the JSON code rendered OOTB is using == now(). (The date field doesn't have a TIME in it, so it's TIME is 12:00:00 AM, and "NOW" is Whatever TIME it is...)

I noticed it YESTERDAY when it said that 10/23 was "today" and showed up YELLOW.

Share via

SharePoint list conditional formatting stopped working

1 answer

Your answer