Conditional Formatting in Excel

This is when you have a set of figures and you would like to have Ms Excel to auto format them with given conditions.

 

Step 1. Highlight the set of figures, Go to File à Format à Conditional Formatting

Step 2 Define the conditions you want, eg. For figures more than 300, I would like to have it colored.

Step 3 Follow through the steps in the pictures shown and you will get the conditional format you want

 

You can add more than one condition too when you do the conditional formatting in Ms Excel.