Thursday, December 27, 2012

Excel: How to Highlight Numerical Cells by using Conditional Formatting

  1. Enter some data in B and C column as like above Excel snapshot 
  2. Select C3 to C17 cells
  3. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then select Highlight Cells Rules
  4. Click Greater Than… 

  5. In the GREATER THAN: box, type 30 and then click OK button.

No comments: