I have some data that requires conditional formatting for easy interpretation. I'd like to change the color of the symbols from blue to red. Is that possible?
Book2 | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | |||
2 | 55 | 50 | 25 | 46 | 46 | 37 | 29 | 25 | 20 | 32 | 26 | 22 | 20 | 20 | 16 | 16 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 18 | 18 | 8 | 0 | 0 | 0 | 0 | ||
3 | 6 | 6 | 4 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | ||
4 | 42 | 42 | 42 | 12 | 12 | 12 | 12 | 12 | 12 | 18 | 18 | 8 | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
5 | 38 | 33 | 36 | 59 | 55 | 51 | 47 | 47 | 37 | 37 | 34 | 46 | 46 | 46 | 48 | 48 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 28 | 28 | 16 | 16 | # | # | ||
6 | 51 | 51 | 16 | 32 | 40 | 32 | 20 | 16 | 14 | 38 | 42 | 32 | 20 | 18 | 18 | 12 | 12 | 12 | 12 | 12 | 18 | 18 | 18 | 26 | 26 | 16 | 16 | 16 | # | # | ||
7 | 60 | 60 | 56 | 56 | 56 | 56 | 56 | 56 | 58 | 58 | 58 | 50 | 50 | 50 | 50 | 50 | 50 | 46 | 46 | 46 | 46 | 46 | 44 | 44 | 44 | 44 | 24 | 24 | # | # | ||
8 | 9 | 8 | 7 | 7 | 7 | 6 | 5 | 3 | 3 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
9 | 44 | 44 | 36 | 34 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 20 | 20 | # | # | ||
10 | 54 | 49 | 44 | 50 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | # | # | ||
11 | 46 | 40 | 28 | 28 | 28 | 28 | 28 | 24 | 24 | 24 | 24 | 12 | 8 | 8 | 8 | 8 | 14 | 6 | 6 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | # | # | ||
12 | 49 | 49 | 63 | 55 | 54 | 54 | 54 | 54 | 44 | 44 | 24 | 24 | 24 | 18 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 15 | 15 | 0 | 0 | ||
13 | 44 | 44 | 44 | 44 | 44 | 44 | 52 | 52 | 52 | 52 | 42 | 42 | 42 | 42 | 42 | 42 | 50 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 12 | 12 | # | # | ||
14 | 28 | 28 | 44 | 44 | 44 | 36 | 36 | 26 | 26 | 26 | 26 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | ||
15 | 44 | 30 | 26 | 42 | 32 | 24 | 24 | 24 | 32 | 32 | 32 | 32 | 28 | 32 | 32 | 16 | 18 | 14 | 14 | 14 | 14 | 14 | 16 | 16 | 16 | 16 | 16 | 16 | # | # | ||
16 | 46 | 50 | 26 | 6 | 16 | 16 | 16 | 24 | 24 | 24 | 24 | 30 | 30 | 30 | 30 | 28 | 28 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | # | # | ||
17 | 12 | 11 | 9 | 8 | 7 | 8 | 8 | 8 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 7 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | ||
18 | 40 | 18 | 18 | 26 | 26 | 26 | 26 | 16 | 20 | 20 | 20 | 20 | 20 | 20 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
19 | 50 | 34 | 38 | 48 | 46 | 38 | 38 | 46 | 52 | 44 | 44 | 40 | 40 | 56 | 22 | 28 | 28 | 10 | 10 | 10 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
20 | 49 | 38 | 38 | 36 | 44 | 44 | 34 | 34 | 34 | 28 | 28 | 32 | 32 | 32 | 32 | 40 | 40 | 32 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | # | # | ||
21 | 42 | 34 | 62 | 64 | 64 | 72 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 60 | 60 | 72 | 72 | 72 | 72 | 68 | 68 | 68 | 68 | 68 | 44 | 44 | 44 | 44 | # | # | ||
22 | 40 | 40 | 40 | 32 | 32 | 32 | 32 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
23 | 39 | 39 | 39 | 47 | 36 | 36 | 36 | 36 | 44 | 44 | 44 | 44 | 44 | 44 | 40 | 40 | 24 | 20 | 12 | 0 | 0 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | # | # | ||
24 | 40 | 28 | 60 | 66 | 98 | 98 | 94 | 86 | 58 | 58 | 58 | 58 | 58 | 48 | 48 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | # | # | ||
25 | 24 | 22 | 22 | 18 | 24 | 32 | 28 | 20 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 20 | 24 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
26 | 25 | 25 | 25 | 37 | 36 | 36 | 36 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 8 | 0 | 0 | 0 | 0 | 0 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | # | # | ||
27 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 32 | 32 | 16 | 16 | 16 | 16 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | ||
28 | 9 | 9 | 9 | 9 | 8 | 8 | 7 | 6 | 7 | 7 | 7 | 7 | 7 | 6 | 6 | 6 | 4 | 4 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | ||
data sets |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E2:AH28 | Other Type | Icon set | NO |