Question

List any five formatting items that can be use for conditional formatting

Answer 1

Highlight Cells Rules - Apply formatting to cells that satisfy a specific condition (e.g. greater than, equal to, Duplicate Values, etc.);

Top/Bottom Rules - Apply formatting to cells that satisfy a statistical condition in relation to other cells in the range (e.g. above average, within top 10%, etc.);

Data Bars / Color Scales / Icon Sets - Apply formatting to all cells in the range, depending on their value in relation to one another;

New rule... - Allows you to specify more complex rules, such as rules that depend on the result of a formula.