Tools for Information Literacy

conditional formatting data

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.

1. On the 02-Conditional Formatting worksheet,
   use the conditional formatting tool on column G to have all the cells that values less than 1789 to display with a blue fill and a white font color

back to top

Hiding data

You can hide or unhide columns in your spreadsheet to show just the data that you need to see or print. For example, you may use data in hidden spaces as factors in formulas or functions, but you may not need to display these factors to the users.

1. On the 03-Hide Column worksheet,
   hide columns B and F
2. On the 04-Hide Row worksheet,
   hide row 63

back to top