Forum Discussion
Formatting SharePoint List based on date values +xx days in the future
Formatting SharePoint List for dummies/beginner
I have SP List that I would like to add conditional formatting to: The raw data is a date, I would like to apply the following rules, but I do not see how to apply +90 days, +30 days or between +30 & +91 days:
Cell Value/Green
Greater than
=TODAY()+90
Cell Value/RED
Less than
=TODAY()+30
Cell Value/Yellow
Between
=TODAY()+30 and =TODAY()+91
1 Reply
Hello EKizzie1970
you can use calculated columns to add dates, after that, you can give them a nice visualization with column or view formatting.
Here are examples to add days: https://support.microsoft.com/en-au/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?WT.mc_id=DX-MVP-5004845
Best, Dave
