folks. We're looking for a code-block to copy/paste for a hopefully simple color-coding-by-date situation in SharePoint modern/Online: a document expiration date.
We want to set a condition on a library's Next Review column (date format) where the item will turn *Yellow if the doc's Next Review date is less than 90 days away *Red if the doc's Next Review date is less than 10 days away or already past (i.e., expired)
We've determined that this will require some sort of conditional formatting, probably using the "JSON" coding. We have no programmers; JSON is a complete black box to us, so we'll be blindly copy/pasting whatever chunk of code we find.
And because SP Online's interface is confusion, we'll need instructions on what values in the chunk of code we need to tweak, as well as instructions on exactly WHERE to paste this code.
You see, a SharePoint Online column doesn't have a single Format box. When you click the column heading and go to Column Settings > Format this Column, you get two tabs: Format View and Format Columns.
The Format View tab has Choose Layout and a code box, while the Format Columns tab has Edit Styles, (conditional formatting) Manage Rules, and Advanced Mode. Unfortunately, there's no online help or documentation for SharePoint Online, so we don't know where to paste any example code that we find. Suggestions appreciated.