Custom formula
Let's combine what we've learned with color ranges and custom formulas.
You are looking through historical sales data to see if order sizes get larger as the end of the year approaches. To this end, a conditional formatting rule that will highlight all dates after November 25, 2005 has already been implemented.
Purchasing departments may have been getting ready for a long holiday break and are therefore increasing the size of their orders.
You want to focus on when ornaments are sold, so use conditional formatting to change the entire line to red font for the lines that have an ornament sale. You will be changing the font color instead of the background color so the formatting can lay over the highlighting from the other rules.
This exercise is part of the course
Conditional Formatting in Google Sheets
Exercise instructions
- Add a conditional formatting rule to the
Unitscolumn using a color range from "White to green" to make the larger orders green and the smaller orders white. - Add a conditional formatting rule to the entire table (except for the headers) using a custom formula that will change the font in the row to the Default "Red text" if the word
Ornamentis in theItemcolumn.- Remember to fix the column but not the row in your custom formula (e.g.
$C2) - Note: The font will stay black in column
Abecause of the overlapping conditional formatting rule from the first instruction.
- Remember to fix the column but not the row in your custom formula (e.g.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise