Excel: Using Conditional Formatting

Conditional formatting allows you to format cells according to conditions applied to the cell contents, in a similar fashion to conditional functions. You can set up conditions based on values (text or numeric), or using a formula to determine what to format. Formatting may include color bars or icons, or text and cell formatting (blue, bold, underline with yellow cell fill).

Conditional formatting example Conditional formatting example


Conditional formatting Conditional formatting rules