-->

Microsoft-Excel 2007 Study Material Day- Seven

Styles Group :
Conditional Formatting : Highlight Cells Rules
This option used to check the condition and apply the formatting styles to the selected cells.we can check more than one conditions and apply formatting styles to the selected cells. 




Highlighted Cells Rules : Greater Than 


Steps :

  • Select the Required data (Example : "Nokia" Column ).
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlight Cell Rules
  • Select Greater Then
  • Type 10 and click the Custom format  
  • Select any Font Color and Style 
  • Click on OK Button
 Highlighted Cells Rules : Less Than 

  • Select the required data (Example : "Samsung" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select Less than
  • Type 15 and click the Custom format 
  • Select the Font Color,Style 
  • Click on OK Button
 Highlighted Cells Rules : Between
  • Select the required data (Example : "LG" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select Between
  • Type 15 and click the Custom format 
  • Select the Font Color,Style 
  • Click on OK Button
  Highlighted Cells Rules : Equals to
  • Select the required data (Example : "HTC" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select Equals to
  • Type 15 and click the Custom format 
  • Select the Font Color,Style 
  • Click on OK Button
  Highlighted Cells Rules : Text that contains 
  • Select the required data (Example : "Sony" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select Text that contains 
  • Type "a" and click the Custom format 
  • Select the Font Color,Style 
  • Click on OK Button
Highlighted Cells Rules : A Date Occurring 
  • Select the required data (Example : "Date" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select A Date Occurring  
  • Select any one format and click the custom format 
  • Select the Font Color,Style 
  • Click on OK Button
Highlighted Cells Rules : Duplicate Values
  • Select the required data (Example : "Location" Column)
  • Click on Home Tab
  • Click on Conditional Formatting
  • Select Highlighted Cell Rules
  • Select Duplicate Values 
  • Select Duplicate or Unique and click the custom format 
  • Select the Font Color,Style 
  • Click on OK Button
To Remove Conditional Formatting :
  • Click on Conditional Formatting .
  • Click on Clear Rules.
  • Then click on Clear rules from selected cells (or) Clear Rules from Entire Sheet. 
Conditional Formatting : Top and Bottom Rules

















Top 10 Items :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Top 10 Items
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Top 10 % :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Top 10 %
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Bottom 10 Items :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Bottom 10 Items
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Bottom 10 % :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Bottom 10 %
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Above Average :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Above Average
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Below Average :
Steps :
  • Select the Achieved Column 
  • Select Conditional Formatting 
  • Select Top and Bottom Rules
  • Select Below Average
  • Select the Custom Format
  • Select the Font Color and Style
  • Click on OK Button
Conditional Formatting : Data Bars and Color Scales and Icon Sets 

















Data Bars : 
Steps :
  • Select color "Data bar"  Column
  • Select Conditional Formatting
  • Select Data Bars
  • Select Any Option
Color Scales : 
Steps :
  • Select color Scales Column
  • Select Conditional Formatting
  • Select Color Scales
  • Select Any Option
Icon Sets : 
Steps :
  • Select color "Icon Sets"  Column
  • Select Conditional Formatting
  • Select Icon sets
  • Select Any Option
Example :
Format As Table :This option used to apply pre-defined table styles to the selected table.
  • Select list range 
  • Select Format as Table 
  • Select any One Table Style
  • Change the table style options
Cell Styles : Quickly format a cell by choosing from pre-defined styles.
  • Select list range
  • click on cell styles on the Home Tab
  • Select Any Styles 




No comments: