Contents
In SharePoint O365, in the modern experience, I have a list of training certificates that have an expiration date of one year from date taken. I would like to use conditional formatting to create a status column that shows me the certificate is one of these: Current, green background – taken sometime within the last 10 months.
I’ve created a new list and are trying to get the columns to turn red/green/yellow depending on the date that you put in to the date-column. No color if no date is selected at all.
Is there way to customize column formatting in SharePoint?
Anyone who can create and manage views in a list can use column formatting to create and publish customizations. Use a Field Customizer for more advanced scenarios that column formatting does not support. To open the column formatting pane, open the drop-down menu under a column. Under Column Settings, choose Format this column.
How to do conditional formatting for contract due date?
I matched the formulas in Excell where they’re working. Here is the working formula tested in Excel, I’m trying to convert in JSON : =IF (B16>TODAY ()+120,”green”,IF (B16-TODAY ()>=0,”orange”,”red”)) where B16 is the cell containing the contract due date. Thanks for contributing an answer to SharePoint Stack Exchange!
Amber if it’s due within 30 days Green if due 30+ days away. Most json codes I find either only have two variables (red or green/overdue or in date) and as far as I can tell the automatic design mode conditional formatting only refers to ‘today’ rather than ‘within a certain number of days to today’.
How to do conditional formatting in date column?
I’m trying to do some simple conditional formatting to a date column but when I use the built in features, it changes the format of the date so it’s not as user friendly Can someone assist me with keeping the date friendly to read?
Where do I find column formatting in SharePoint?
Get started with column formatting To open the column formatting pane, open the drop-down menu under a column. Under Column Settings, choose Format this column. If no one has used column formatting on the column you selected, the pane will look like the following.