[2024] - 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

{
"elmType": "div",
"debugMode": true,
"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!

[juanbon]

Great stuff!!! thank you. I will be using this knowledge to highlight specific data on my lists.

[prochefpos]

Hi Amy, I have a question. I am just trying to learn sharepoint lists and so far managed to import a table from ms access. it seems like i cannot change a imported column from a single line text to a calculated column. I can do this ONLY when i create a new column. Why is this ?

[Shellbell]

Great video, is it possible for the cell colour to be changed instead of the actual font colour?