Conditional Formatting

What is the purpose of conditional formatting? When would you use it? What are the advantages and disadvantages, if any, to using conditional formatting?

Create a new workbook and enter the numbers of your choice in a worksheet. Then practice applying conditional formatting to the numbers. Attach the worksheet and explain the conditional formatting you used, such as purpose, criteria and results expected.