15  3. Hover over  Highlight Cell Rules . 4. Select  Less Than  to open the Less Than dialogue box.  1. Highlight the data range. 2. Select  Conditional Formatting . 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. 4. Select  Greater Than  from the menu to open the Greater Than dialogue box: The cells which contain a value greater than the value you specified will now appear with the cell  formatting which you selected. To highlight cells that contain data less than a specific value:  Less Than 