B03 Highlight Values with Conditional Formatting 1:33

prev < Numbers ’09 > next

1
00:00:01,167 --> 00:00:03,303
Highlight values with
Conditional Formatting

2
00:00:03,303 --> 00:00:05,905
Conditional formatting let you apply rules

3
00:00:05,905 --> 00:00:07,674
that would change the look of the cell

4
00:00:07,674 --> 00:00:09,609
when a certain condition is match.

5
00:00:09,609 --> 00:00:12,412
So it's easy to see when
your Hating Savings targets

6
00:00:12,412 --> 00:00:14,547
in this Energy saving spreadsheet.

7
00:00:16,449 --> 00:00:18,918
First select the cell containing the value

8
00:00:18,918 --> 00:00:20,820
you want to monitor.

9
00:00:20,820 --> 00:00:22,355
Then go to the "Format" menu

10
00:00:22,355 --> 00:00:25,392
and choose "Show Conditional Format Rules".

11
00:00:27,193 --> 00:00:29,596
In the "Conditional Format"
window that appears,

12
00:00:29,596 --> 00:00:31,197
go to the rule pull down menu

13
00:00:31,197 --> 00:00:33,533
and choose "Greater then"

14
00:00:33,533 --> 00:00:36,436
and then enter 50 in the box.

15
00:00:36,436 --> 00:00:40,607
Next click "Edit" to select the color
and text style for the value

16
00:00:40,640 --> 00:00:43,176
and color for the cell background.

17
00:00:43,176 --> 00:00:46,780
The sample box shows you what your
formatting changes would look like

18
00:00:46,780 --> 00:00:49,949
when the Yearly Savings exceed 50 dollars.

19
00:00:49,949 --> 00:00:51,184
When you're satisfied

20
00:00:51,184 --> 00:00:52,485
click "Done".

21
00:00:52,485 --> 00:00:54,187
You can combine rules too

22
00:00:54,187 --> 00:00:56,189
by clicking the "Add" button (+).

23
00:00:56,189 --> 00:00:58,024
Then from the rule pull down menu

24
00:00:58,024 --> 00:00:59,592
choose "Less then".

25
00:00:59,592 --> 00:01:02,729
You can link to an existing cell
or just type in a value.

26
00:01:04,230 --> 00:01:07,300
Next click "Edit" to select
the formatting to be applied

27
00:01:07,300 --> 00:01:10,236
when the cell value is less then 25 dollars.

28
00:01:13,106 --> 00:01:15,075
And then click "Done".

29
00:01:15,075 --> 00:01:17,577
Now when the cell is below its savings target

30
00:01:17,577 --> 00:01:18,912
it would turn red

31
00:01:18,912 --> 00:01:20,747
and when it's over its saving target

32
00:01:20,747 --> 00:01:22,182
it would turn green

33
00:01:22,182 --> 00:01:25,952
making it easier to interpret
the data in a cell as a glance.

34
00:01:25,952 --> 00:01:28,288
With Numbers we have all the tools you need

35
00:01:28,288 --> 00:01:30,223
to make it easier to understand your data.
All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.