Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
Your boss has given you a list of data and asked you to identify who your star customers are (your top 30%). How would you highlight only your top customers?
Highlight the column and create a new Top 10% rule, then adjust it to top 30%
Write a formula to identify if each customer is in the top 30% of spenders
Highlight the total spend column for the customers and apply data bars to it
Suppose cells D10:D50 contain a range of numbers. How do you quickly color all values over $5,000?
Sort the data in D10:D50 and then color it
Set up a Greater Than 5000 conditional formatting rule for D10:D50
Write the formula =IF(D10>5000,”Over”,””) in E10 and copy it down the table
Suppose you want to identify the top 25% and bottom 25% of values in a column of data. Which method is the best?
Set up a Top 10% and Bottom 10% conditional formatting rule, changing the % to 25% for each one
Sort the data in ascending order and use a formula to determine which cells fit into each quartile
Set up a Highlight Cells Between conditional formatting rule