Apply Conditional Formatting for MS Excel

Apply Conditional Formatting
This option is used to format the cell depending upon the condition.  Following are the steps

• Select one or more cells in a range,  or table that is on be Apply formatting. 
• On the Home tab,  in the Styles group,  click Conditional Formatting icon. 
• Select Highlight cells Rules and click Between. 
• From the Between dialog box displayed,  choose the formatting you wish to use from the dropdown.  Line default is a Tight Red with Dark Red Text".
• Click OK. 
• The background color of all values that appear more that once in the selected ranges will chow the selected formatting.