Color Scales

Up Your Microsoft Excel Skills Conditional Formatting
1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€95.55
List Price:  €133.77
You save:  €38.22
£79.30
List Price:  £111.02
You save:  £31.72
CA$141.90
List Price:  CA$198.66
You save:  CA$56.76
A$157.20
List Price:  A$220.09
You save:  A$62.88
S$134.19
List Price:  S$187.87
You save:  S$53.68
HK$777.47
List Price:  HK$1,088.50
You save:  HK$311.02
CHF 90.03
List Price:  CHF 126.04
You save:  CHF 36.01
NOK kr1,113.09
List Price:  NOK kr1,558.38
You save:  NOK kr445.28
DKK kr712.70
List Price:  DKK kr997.81
You save:  DKK kr285.11
NZ$175.11
List Price:  NZ$245.17
You save:  NZ$70.05
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,166.46
List Price:  ৳17,033.53
You save:  ৳4,867.07
₹8,691.60
List Price:  ₹12,168.59
You save:  ₹3,476.99
RM444.50
List Price:  RM622.32
You save:  RM177.82
₦150,999.89
List Price:  ₦211,405.89
You save:  ₦60,406
₨27,959.15
List Price:  ₨39,143.93
You save:  ₨11,184.78
฿3,368.76
List Price:  ฿4,716.40
You save:  ฿1,347.64
₺3,627.05
List Price:  ₺5,078.02
You save:  ₺1,450.96
B$572.50
List Price:  B$801.52
You save:  B$229.02
R1,838.04
List Price:  R2,573.33
You save:  R735.29
Лв186.91
List Price:  Лв261.69
You save:  Лв74.77
₩144,050.71
List Price:  ₩201,676.76
You save:  ₩57,626.04
₪356.60
List Price:  ₪499.25
You save:  ₪142.65
₱5,816.56
List Price:  ₱8,143.42
You save:  ₱2,326.86
¥15,183.26
List Price:  ¥21,257.18
You save:  ¥6,073.91
MX$2,025.94
List Price:  MX$2,836.40
You save:  MX$810.45
QR365
List Price:  QR511.01
You save:  QR146.01
P1,382.22
List Price:  P1,935.16
You save:  P552.94
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£5,060.50
List Price:  E£7,084.90
You save:  E£2,024.40
ብር12,853.61
List Price:  ብር17,995.56
You save:  ብር5,141.95
Kz91,190.88
List Price:  Kz127,670.88
You save:  Kz36,480
CLP$94,785.52
List Price:  CLP$132,703.52
You save:  CLP$37,918
CN¥727.91
List Price:  CN¥1,019.11
You save:  CN¥291.19
RD$6,215.25
List Price:  RD$8,701.60
You save:  RD$2,486.34
DA13,481.55
List Price:  DA18,874.71
You save:  DA5,393.16
FJ$229.81
List Price:  FJ$321.75
You save:  FJ$91.93
Q772.59
List Price:  Q1,081.66
You save:  Q309.06
GY$20,950.95
List Price:  GY$29,332.18
You save:  GY$8,381.22
ISK kr14,017.59
List Price:  ISK kr19,625.19
You save:  ISK kr5,607.60
DH997.60
List Price:  DH1,396.68
You save:  DH399.08
L1,864.97
List Price:  L2,611.03
You save:  L746.06
ден5,879.23
List Price:  ден8,231.16
You save:  ден2,351.92
MOP$802.38
List Price:  MOP$1,123.37
You save:  MOP$320.98
N$1,845.90
List Price:  N$2,584.33
You save:  N$738.43
C$3,684.65
List Price:  C$5,158.65
You save:  C$1,474
रु13,912.57
List Price:  रु19,478.15
You save:  रु5,565.58
S/370.44
List Price:  S/518.64
You save:  S/148.19
K402.76
List Price:  K563.88
You save:  K161.12
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,816.41
List Price:  ZK3,943.09
You save:  ZK1,126.67
L475.58
List Price:  L665.83
You save:  L190.25
Kč2,396.16
List Price:  Kč3,354.72
You save:  Kč958.56
Ft38,385.49
List Price:  Ft53,741.23
You save:  Ft15,355.73
SEK kr1,071.44
List Price:  SEK kr1,500.06
You save:  SEK kr428.62
ARS$105,926.90
List Price:  ARS$148,301.90
You save:  ARS$42,375
Bs694.44
List Price:  Bs972.25
You save:  Bs277.80
COP$413,151.75
List Price:  COP$578,428.98
You save:  COP$165,277.22
₡50,717.92
List Price:  ₡71,007.11
You save:  ₡20,289.19
L2,552.87
List Price:  L3,574.13
You save:  L1,021.25
₲791,418.37
List Price:  ₲1,108,017.38
You save:  ₲316,599.01
$U4,324.45
List Price:  $U6,054.41
You save:  $U1,729.95
zł397.30
List Price:  zł556.24
You save:  zł158.93
Already have an account? Log In

Transcript

Conditional Formatting color scales help us determine patterns and trends within the data. So the first step would be select your data, Home tab, conditional formatting, color scales. So at first, I recommend you just hover over each one and try to see if you see a pattern here, which I do I happen to see, New York has the largest values. So after you decide to click one that will do it kind of step back, kind of, you know, rearview mirror, you can look at the data here from a high level view and just discovered that New York has the largest values averaging over all the rest of them. Do you want it to change up kind of how it looks go to conditional formatting, Manage Rules, and you can actually pick your own colors? In other words, what do you want the high values to look like?

And pick your color here. So if I'd like it to be red for hot and maybe blue For cold, I'm going to kind of just kind of create a little range like that. And that's going to be my barometer if you will, from that. So great way to analyze data and look for heart hard large numbers or small numbers here.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.