JSON formatting to show in bold AND conditional fomatting based upon dates

Question

Hello,

I posted this question in the Microsoft Community forum: https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-lists-conditional-formatting-very/c70832f1-a6a6-40cb-a7f7-ec8f318547c3, but I've been advised to post it in the Microsoft Q&A section instead. I've found the answer to my question through having a search through the Tech Community: https://techcommunity.microsoft.com/t5/sharepoint/conditional-format-sharepoint-list-due-dates-with-three/m-p/1586928

What I'd also like to do is to have the data that appears in the column to present in bold. How do I combine the recommended JSON in: https://techcommunity.microsoft.com/t5/sharepoint/conditional-format-sharepoint-list-due-dates-with-three/m-p/1586928 with some additional lines to achieve this?

I've been able to apply the background colours to the column, but I can't figure out how to add the additional JSON language to make the text to appear bold too.

Your advice and guidance would be much appreciated, as I'm a complete novice at this, so thank you in advance!

Answer 1

Hello @Stephen Cox ,

Welcome to Q&A Forum!

Please use the below JSON formatting:

{  
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
    "elmType": "div",  
    "txtContent": "@currentField",  
    "style": {  
        "background-color": "=if(Number(@currentField) == 0, '', if(@currentField >= @now + 2592000000, '#AFF8C9', if(@currentField >= @now + 86400000, '#EEBB2F', if(@currentField <= @now, '#F06C47',''))))",  
		"font-weight": "bold"   
    }  
}  

Reference:

• CSS font-weight Property
• Use column formatting to customize SharePoint

Thanks,
Echo Du

=============================================================

If the answer is helpful, please click "Accept 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.