In the example below, a hypothetical plant nursery is reviewing the sales data for the month and wants to highlight the bellflower data only. In order to better understand the concept of conditional formatting, let’s look at an instance where conditional formatting comes in handy. If you would like to learn more about conditional formatting, then see our Excel Course Offerings.