How to do conditional formatting in Excel?
🚨 Test your Excel skills (with answers) and receive exclusive resources 🎯
➜ https://www.morpheus-formation.fr/blo...
🎁 Take our free Excel training → https://www.morpheus-formation.fr/for...
🏆 Excel training eligible for CPF – Up to 100% fundable, all levels, 100% personalized → https://www.morpheus-formation.fr/for...
💡 ABOUT THIS VIDEO
🥶 In this video, I tackle the pet peeve of all beginners: the absolute reference (the $)!
Absolute and mixed references allow you to freeze the row and/or column of a cell in a formula. In other words, they are useful when copying your formula into adjacent cells.
Watching this video will help you differentiate between the three types of references in Excel: relative (A1), absolute ($A$1), and mixed ($A1 or A$1).
🏢 WHO ARE WE?
Morpheus Formation is an organization 100% specialized in Excel and its latest innovations.
Have your company and your profession evolved over the past 15 years? Has Excel evolved too!
With a satisfaction rating of 9.8/10 in 2024, we have already supported more than 500 learners and 50 companies, including Pernod Ricard, Cartier, and Orange.
Our Excel training courses are suitable for both businesses and individuals, with personalized support for your own files.
🎓 OUR EXCEL TRAINING COURSES
1️⃣ Personalized training, delivered live by an expert trainer, tailored to your needs.
2️⃣ Exclusive exercise materials and the ability to work on your files during sessions.
3️⃣ An ultra-flexible schedule (weekdays, holidays, weekends, etc.).
📌 Excel training for all levels → https://www.morpheus-formation.fr/for...
💡 CHAPTERS
0:00 - Introduction to conditional formatting in Excel
0:05 - Overview of conditional formatting in Excel
0:30 - Overview of Morpheus Formation and its Excel training courses
1:22 - Formatting a value in Excel
5:40 - Formatting text in Excel
8:31 - Formatting a date in Excel
10:00 - Formatting with data bars in Excel
11:52 - Formatting with icon sets in Excel
13:25 - Formatting unique and duplicate values in Excel
14:49 - Formatting empty and filled cells in Excel
19:41 - Conditional formatting applied to an entire row in Excel Excel
22:13 - Priority of Formatting Rules in Excel
23:24 - Using Filters with Conditional Formatting in Excel
24:22 - Conclusion and Additional Resources for Excel
🎁 OTHER FREE RESOURCES
📂 20 Excel Exercises to Improve Quickly → https://www.morpheus-formation.fr/blo...
📥 Free PDF: 25 Essential Excel Functions → https://www.morpheus-formation.fr/blo...
⌨️ 20 Excel Keyboard Shortcuts to Remember → https://www.morpheus-formation.fr/blo...
📬 FOLLOW US
🌐 Official Website → https://www.morpheus-formation.fr/
💼 LinkedIn → / morpheus-formation