Productivity & Collaboration Tools     Microsoft Office 365     Excel 365

---

To customize data even further, you can create your own conditional formatting in Excel 365.
In this course, you will observe how to create and use conditional formatting, work with intelligent data types, and convert values from the default base-10 number system into binary and hexadecimal. To start, you will discover how to apply advanced conditional custom formatting to data values and create conditional formatting rules to enhance how your data values display. You will also delve into managing conditional formatting rules and using intelligent data types that can be mapped automatically to existing values in a data range, thereby enriching your worksheets and reports.

---

---

Objectives

Excel 365: Applying custom formatting discover the key concepts covered in this Microsoft 365: Applying custom formatting in Excel 365 course use conditional formatting to analyze a data range in Excel 365 use advanced conditional formatting tools in Excel 365 manage conditional formatting rules in Excel 365 use intelligent data types in Excel 365 convert numbers with BIN and HEX in Excel 365 Knowledge Check: Applying custom formatting in Excel 365