Conditional Formatting Custom Formula
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Example 1: Conditional Formatting a Whole Range Based on Selected Values
2
Most Sales
3
MonthStateValue
4
JanuaryQueensland$1,561,618.00
5
FebruaryNew South Wales$1,666,597.00
6
MarchSouth Australia$2,655,499.00
7
AprilQueensland$2,166,547.00
8
May
Western Australia
$6,516,988.00
9
JuneNew South Wales$6,517,243.00
10
JulyNew South Wales$6,516,654.00
11
AugustVictoria$4,165,488.00
12
SeptemberTasmania$2,335,647.00
13
OctoberNew South Wales$3,654,977.00
14
NovemberVictoria$3,556,444.00
15
December
Northern Territory
$5,266,811.00
16
*If New South Wales, then Blue. If Queensland, then Maroon.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu