Microsoft Excel: Conditional Formatting

Conditional Formatting is data formatting but only made easier.

We only use formulas in formatting cells not formatting them one by one in Cell Formatting.

Here are the steps on how to apply Conditional Formatting:

     1) Input all of your data

     2) Click the cell you want to format

     3) Click Conditional Formatting in the Ribbon

     4) Click New Rule

     5) When adding a rule, make sure you use a formula.

     6) Add your Rule

     7) Click on Format

     8) Select Formatting you want for your cell.

     9) Done : D