Highlight Cells Rules

Using this option you can highlight cells greater or less than especific number, between two values, equal to a value, or highlight text wich contains especific text. Also you can select a range and duplicate values.

Example:

Select the cells containing the data that you want to apply the rule on and go to Conditional Formatting ---> Highlight Cell  Rules---> More than ">"

Step 2. Select the conditions for the rule you want to set

You can set the rule the way you want to and there are many other options on Highlight Cell Rules.