Conditional Formatting

 






What is the use of conditional formatting?

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, when the data in that cell meets the conditions that you have set.

                                           Where can we apply conditional formatting?

The use of conditional formatting is very efficient.

We can apply conditional formatting for the dates, for duplicating data and for values that are above or below the average value in a range of cells.

Reference: http://spreadsheets.about.com
Image Source: https://images.search.yahoo.com