Highlighting cells between a range

In this next task, you will create a rule that will highlight cells in the Close column if the value in the cell falls between a certain range.

This exercise is part of the course

Data Visualization in Google Sheets

Exercise instructions

Highlight the Close data in F17:F26 and create a rule that bolds the text and sets the font color to 'blue' when the value is between 0.040 and 0.050.
Make sure the background color in the conditional formatting is set to 'white'.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises