content_image/731580.jpg content_image/731581.jpg content_image/731582.jpg
<img src='content_image/731580.jpg'>

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. 

## Between 

To highlight cells between two specific values: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

<img src='content_image/731581.jpg'>

3. Hover over Highlight Cells Rules  to reveal the menu of different rules. 

4. Select Between  to open the Between dialogue box. 

<img src='content_image/731582.jpg'>

5. Enter the lower limit in the first box and the upper limit in the second box. 

6. Select the cell formatting. 

7. Select Ok . 

The cells which contain a value between the two specified values will now appear with the cell formatting which you selected. 

## Equal To 

To highlight cells equal to a specific value: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

