content_image/867620.jpg content_image/867621.jpg content_image/867622.jpg
<img src='content_image/867620.jpg'>

4. Select Greater Than  from the menu to open the Greater Than dialogue box: 

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

5. Enter the value that you want to set as your lower limit for the Greater Than condition. 

6. Select the type of formatting from the dropdown menu. 

7. Select Ok. 

The cells which contain a value greater than the value you specified will now appear with the cell formatting which you selected. 

## Less Than 

To highlight cells that contain data less than a specific value: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

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

3. Hover over Highlight Cell Rules . 

4. Select Less Than  to open the Less Than dialogue box. 

