home & schedule | syllabus | contact | grades

Now we'll work on other worksheets to do conditional formatting and hiding data

Still using your downloaded workbook ...

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 F to have all the cells that contain NC to display with a blue fill and a white font color

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 B&L worksheet,
   hide columns B and L
2. On the 04-Hide Democratic Districts worksheet,
   hide all the rows relating to Democratic congressional districts (which are designated by color formatting)

week of 30 March lab | setting up a worksheet | setting up a workbook | other tools | functions, formulas, formatting