Custom formatting is applied to all cells for which the parsed and calculated formula expression returns TRUE.
In the example above, cells in the Value 2 column are highlighted if its value is larger than the value in the Value 1 column. See this topic for more details on using formulas.