Tools for Information Literacy ⑪ Data control

Conditional formatting

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

Why we do this	What we are to do
to highlight a value in the data	On the 02-Conditional Formatting worksheet, use the conditional formatting tool on column G to have all the cells that contain values less than 1789 to display with a light red fill with a dark red text. Apply the conditional formatting to cells that show a value, not to blank cells.