Articles → EXCEL → Conditional Formatting In Excel 2007

Conditional Formatting In Excel 2007

Software Requirement

Prerequisite Knowledge

Open A New Excel

Add Data In Excel

Picture showing the sample excel file on which conditional formatting will be applied
Click to Enlarge

Change Row Colors Using Conditional Formatting In Excel

  1. Select the column(on which you want to do column formatting)
  2. Click on ‘Conditional Formatting’ tab.
  3. Click on ‘Highlight Cells Rules’ – ‘Greater Than..’ option.
Picture showing adding the conditional formatting for Greater Than. rule in excel
Click to Enlarge

Picture showing the popup window to set the max value and the range on which conditional formatting is applied
Click to Enlarge


Picture showing the excel file after the conditional formatting is applied
Click to Enlarge

Posted By  -  Karan Gupta
Posted On  -  Saturday, March 16, 2013


Your Email Id  
Query/FeedbackCharacters remaining 250