16  2. Select  Conditional Formatting . 1. Highlight the data range. 7. Select  Ok . 6. Select the cell formatting. 5. Enter the lower limit in the first box and the upper limit in the second box. 1. Highlight the data range. 2. Select  Conditional Formatting . 3. Hover over  Highlight Cells Rules  to reveal the menu of different rules. 4. Select  Between  to open the Between dialogue box.  5. Enter the value that you want to set as your upper limit for the Less Than condition 6. Select  Ok . The cells which contain a value less than the value you specified will now appear with the cell  formatting which you selected.  To highlight cells between two specific values:  The cells which contain a value between the two specified values will now appear with the cell  formatting which you selected.  To highlight cells equal to a specific value:  Equal To  Between 