Excel Tip: Conditional Formatting

Conditional formatting is a feature within Microsoft Excel which is used for highlighting cells with a certain color, depending on the cell’s value. It can be a great tool for your Excel sheets, as it has various purposes and outcomes, whether you are after the top 5 values or a simple way to values that need your urgent attention.


To get to conditional formatting, go to the Home tab, then to the Styles command group:

conditional formating


There are plenty of in-built options for users who don’t want to modify anything or want to do things on the go. However, Excel gives users the chance to customize their own rules for conditional formatting for that added personal touch.


Conditional Formatting


To customize your own rules, follow the same steps above, select the New Rule command to bring the New Rule Dialogue Box.


Want to learn more? Check out our Courses and our other Hints and Tips


0 Responses to “Excel Tip: Conditional Formatting”

  1. No Comments

Leave a Reply