Conditional Text Tutorial | When Conditional Color Formatting Isn’t Enough | MS Excel

Conditional text - unlike conditional color formatting - not only tells you whether important things are happening with your data, but can also reinforce why it's important and what action you might need to take as a result. In this video, I provide a guide to using conditional text in your workflows, including which function to use when, and discuss how to efficiently combine conditional text with conditional color formatting.

Subscribe to the Blou Designs newsletter "Small Things Add Up":
http://mailchi.mp/27d6ba9cfbfb/newsle...
This newsletter is for service-based business folks who want systematic solutions to turn their days from uncertainty & herding cats into ducks in a row - one step at a time.

If this is something you want more help with, or you just want to follow me to find out more, you can find me at:
LinkedIn:   / barbara-olsafsky  
follow and/or DM me for more on SOPs, Data Strategy (including working with data in Excel), and aligning your efforts with your goals
Website / Schedule a Zoom: https://www.bloudesigns.com/contact-f...

Contents of this Video -
00:00 Why you need conditional text
00:47 Disclaimer
00:53 Guide to Using Conditional Text and Picking a Function
02:59 Functions for Displaying Conditional Text
04:50 IF Function for Conditional Text
08:25 IFS Function for Conditional Text
10:51 SWITCH Function for Conditional Text
13:05 Combining Conditional Text with Conditional Color Formatting
15:53 Recap + Your Turn
17:06 Wrap-up


Subscribe to this channel:    / @bloudesigns  

Behind the scenes:

Video Editing with Techsmith's Camtasia (plus some screen captures):
https://techsmith.z6rjha.net/YgjBNJ

Audio Recording with (free) OBS Studio:
https://obsproject.com/

Note: This description contains affiliate links, which means that at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

---
All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.