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




Output


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

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

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250