User Profile
DWOps
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Conditional formatting for dates based on another cell value
Hi, I am trying to add conditional formatting to my sharepoint list but cant figure out the answer for my scenario. I want to change the rows to orange if the column 'Status' shows "Awaiting Payment" and todays date is between 30 and 60 days after the date in the 'Date bill sent to client' column. I then want to change the rows to red if todays date is 60 days or more after the date in the 'Date bill sent to client' column and the 'Status' is still "Awaiting payment". Any help much appreciated 🙂Solved2.5KViews0likes3Comments
Groups
Recent Blog Articles
No content to show