Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. Highlight Cells Rules To highlight cells that are greater than a value, execute the following steps. 1. Select the range A1:A10. 2. On the Home tab, in the Styles group, click Conditional Formatting. 3. Click Highlight Cells Rules, Greater Than. Read More