What is conditional formatting? Conditional Formatting is formatting for cells that meet specific criteria.How do you create conditional formatting? Conditional formatting is set by clicking the Conditional Formatting command in the Styles Group on the Home tab. You can use any of the pre-formatted options or choose new rule to open the New Rule formatting dialog box. When a cell meets the criteria set, it will be formatted the way you set it to look.