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










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