Excel 365 in 30 Minutes – Formatting (Intermediate 3 of 8)

Topics covered include: 

• Selecting a cell format from the Format Cells dialog box 

• Creating and modifying a Custom Number Format. 

• Removing formatting from a cell using Clear Formats command. 

• Applying Conditional Formatting Rules to text 

• Applying Conditional Formatting Rules to dates 

• Applying 3 types of Comparative Analysis Formatting 

• Describing how Comparative Analysis Formatting is applied 

• Creating a new rule from the New Formatting Rule dialog box  

• Customizing rules using the Rules Manager 

• Setting rule precedence in the Conditional Formatting Rules