Excel in 30 Minutes – Conditional Formatting

What does conditional formatting allow you to do?

Apply formatting to cells that meet certain criteria

Convert a range of cells to a table

Continue a series or pattern into neighboring cells

What conditional formats make it easier to compare the values of a range of cells at the same time?

Data bars

Color scales

Icon sets

All of the above

What are templates?

Add-ins used to enhance your spreadsheet

Collection of colors, fonts, and effects that you can apply to a workbook

Predesigned spreadsheets you can use to create new spreadsheets with the same formatting and predefined formulas

Information