Scribd
Upload
43 views3 pages

Conditional Formatting Techniques Explained

The document contains a collection of numerical data, words, and formatting options organized into various categories. It includes lists of values, words containing the letter 'X', and different formatting techniques such as data bars and color scales. Additionally, there are icon sets and custom rules for conditional formatting, indicating a focus on data visualization and analysis.

Uploaded by

gustitrisna04
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
43 views3 pages

Conditional Formatting Techniques Explained

The document contains a collection of numerical data, words, and formatting options organized into various categories. It includes lists of values, words containing the letter 'X', and different formatting techniques such as data bars and color scales. Additionally, there are icon sets and custom rules for conditional formatting, indicating a focus on data visualization and analysis.

Uploaded by

gustitrisna04
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Greater than ten Above average Duplicate values

12 2 1 17 18 56 76 78 18
5 6 7 39 84 37 48 68 84
2 11 6 35 11 59 13 39 47
8 7 9 17 100 12 64 3 89
1 1 5 84 81 83 17 44 14
10 12 11 77 69 81 44 35 65
6 6 8 47 93 47 34 66 80
3 3 7 64 94 68 34 10 76
1 10 10 15 39 81 65 96 6
9 1 6 83 10 63 26 2 87

Words that contain X Data bars Color scale


apple kite urn 8 -1 6 1 11 21
baby light violin -3 10 -2 2 12 22
cry max wax 3 9 -3 3 13 23
dog night X-ray 7 6 1 4 14 24
elf oxen young 10 -1 -1 5 15 25
fox purple zebra -1 4 3 6 16 26
garage quaint angle 9 8 7 7 17 27
hex right boy -3 10 6 8 18 28
icon sled chump -2 3 -3 9 19 29
jewel turtle dusty 1 -2 0 10 20 30

Icon set Icon set Custom rule


73 61 18 3 1 1
79 92 93 2 5 0
23 36 82 5 3 5
67 15 95 4 5 0
7 44 68 1 5 3
40 81 68 3 5 1
52 66 89 3 5 0
2 35 71 5 0 2
78 27 87 1 1 2
94 19 35 0 2 0
83 55 81 1 2 1
33 3 types of conditional formatting
11
33
36
49
45
53
35
52
42
59
36
15
50
49
15
26
50
37
26
al formatting

You might also like