Select the cells you want to format
Go to the Home tab
Click Conditional Formatting
Choose a rule type
Select a preset rule or click New Rule
Set the condition or formula
Choose the formatting style
Click OK
Apply the rule
Use Manage Rules to edit or delete rules
Use Clear Rules to remove conditional formatting