Use conditional formatting in Excel to automatically highlight cells based on their content. Apply a rule or use a formula to determine which cells to format.
How to Do Conditional Formatting in Excel To add conditional formatting, select your data, click on Home from the top menu, and choose Conditional Formatting. Create a new rule to set the conditions and cell colors for the conditions that you set. Click on OK when you're finished to save your formatting rules.
Conditional formatting in Excel is formatting that changes with the cell content. That means you don’t have to change it when the cell content changes. You use conditional formatting to make it easier for the user to identify key points of interest. That could be: Or a lot of other things.