How to Apply Custom Conditional Formatting to a Calculated Date Column in Microsoft Lists
In this video, I will show you how to create a calculated column in Microsoft Lists and apply custom conditional formatting. The calculated field is a nested IF statement to return values based on a date column. We will use JSON to apply custom conditional formatting based on a date column using a nested IF Statement. I will break this down into bite size steps. We will also uncover some of my favourite tips in Microsoft Lists! If you are a student, project manager, business owner or super nerd like me, then we have got you covered!
JSON
{
"$schema": "https://developer.microsoft.com/json-...",
"elmType": "div",
"debugMode": true,
"txtContent": "@currentField",
"style": {
"color": "=if()"
}
}
OFFICE SKILLS WITH AMY
Welcome to Office Skills with Amy! We create easy-to-follow and engaging how-to-technology videos to help you boost your productivity and save time in the office.
DISCOVER YOUR INNER NERD
We believe that being a 'nerd' is a term of pride, I personally, have been advertising myself as an Excel Nerd in interviews since 2009.
Our goal is to inspire you to unleash the power of technology and Discover Your Inner Nerd along the way. We're here to show you how to make the most out of Microsoft 365 apps and other cutting-edge technology
WHAT WILL YOU LEARN
Whether you're a beginner or an experienced user, we'll help you become more efficient, automate tasks, and save time.
NEW CONTENT WEEKLY
With new content every week, we'll keep you up-to-date on the latest technology trends and help you stay ahead of the curve.
TECHNOLOGY VIDEOS TO COME
Microsoft 365 apps including Microsoft Office, Microsoft Loop, Microsoft Teams, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook, Microsoft OneNote and more!
LIKE, COMMENT & SUBSCRIBE
Don't forget to like, comment, and subscribe to our channel to show your support and stay tuned for more technology videos to come. Let's Nerd Out together and unleash the power of technology!