Conditional formatting


show more Conditional formatting provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Conditional formatting

Numbers '09 allows you to format table cells based on conditions you set. Conditional formatting changes a cell's appearance when the cell contains a particular value, referred to as a test value. For example, let's say we want the totals in our Distance Run table in our Running Club spreadsheet to appear differently depending whether or not they are greater or less than the goal amount that appears in our Monthly Goal table. First, we need to select the cells to use our conditional formatting. In this case, all of the totals for January through September.

Once we've got our cells selected, we can create the rule either from the Cells Inspector or directly from the Format menu. Here, we'll select Show Conditional Format Rules. This opens up the Conditional Format window where we can first choose a rule. Click the button to display a number of rules to choose from. Let's say we want our numbers to appear Bold and Red if they're below the monthly goal. In that...

Conditional formatting
Video duration: 3m 28s 3h 53m Beginner

Viewers:

Conditional formatting provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...