Download the free course files and follow along here:
https://www.simonsezit.com/conditional-formatting-in-excel-demo-file

Discover the essentials of Excel's conditional formatting tools to enhance your data analysis and presentation skills. Learn how to apply highlight cells rules, utilize data bars, color scales, and icon sets, and manage your formatting rules effectively. Understand how to handle special cases like blank cells and value comparisons, and see how highlighting entire rows based on conditions can transform your spreadsheets.

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 - Course Introduction
00:03:20 - Highlight Cells Rules
00:10:27 - Manage Rules and Clear Rules
00:13:39 - Data Bars, Color Scales, and Icon Sets
00:22:57 - Blank Cells
00:26:12 - Working with Formulas
00:32:41 - Value Comparison
00:39:35 - Highlighting Rows
00:45:42 - Course Conclusion

Get unlimited training with Simon Sez IT’s 200+ courses https://www.simonsezit.com/courses/

Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! https://simonsezit.lpages.co/ssit-14-day-free/

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 400+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

For a full training experience, check out our FREE YouTube course: https://www.youtube.com/@SimonSezIT/courses

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)