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
$49.99
List Price:  $69.99
You save:  $20
€47.72
List Price:  €66.82
You save:  €19.09
£39.70
List Price:  £55.58
You save:  £15.88
CA$70.94
List Price:  CA$99.32
You save:  CA$28.38
A$78.51
List Price:  A$109.92
You save:  A$31.41
S$67.05
List Price:  S$93.88
You save:  S$26.82
HK$388.89
List Price:  HK$544.49
You save:  HK$155.59
CHF 45
List Price:  CHF 63.01
You save:  CHF 18
NOK kr556.16
List Price:  NOK kr778.67
You save:  NOK kr222.51
DKK kr356.02
List Price:  DKK kr498.46
You save:  DKK kr142.43
NZ$87.17
List Price:  NZ$122.05
You save:  NZ$34.87
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.45
৳6,052.37
List Price:  ৳8,473.80
You save:  ৳2,421.43
₹4,341.99
List Price:  ₹6,079.14
You save:  ₹1,737.14
RM221.65
List Price:  RM310.33
You save:  RM88.68
₦75,475.40
List Price:  ₦105,671.60
You save:  ₦30,196.20
₨13,904.29
List Price:  ₨19,467.12
You save:  ₨5,562.83
฿1,685.56
List Price:  ฿2,359.92
You save:  ฿674.36
₺1,811.06
List Price:  ₺2,535.63
You save:  ₺724.57
B$285.10
List Price:  B$399.17
You save:  B$114.06
R922.45
List Price:  R1,291.51
You save:  R369.05
Лв93.26
List Price:  Лв130.57
You save:  Лв37.31
₩72,146.06
List Price:  ₩101,010.26
You save:  ₩28,864.19
₪177.78
List Price:  ₪248.91
You save:  ₪71.12
₱2,900.74
List Price:  ₱4,061.27
You save:  ₱1,160.53
¥7,588.73
List Price:  ¥10,624.83
You save:  ¥3,036.10
MX$1,019.62
List Price:  MX$1,427.55
You save:  MX$407.93
QR181.59
List Price:  QR254.24
You save:  QR72.65
P687.07
List Price:  P961.95
You save:  P274.88
KSh6,456.20
List Price:  KSh9,039.20
You save:  KSh2,583
E£2,528.80
List Price:  E£3,540.53
You save:  E£1,011.72
ብር6,380.16
List Price:  ብር8,932.73
You save:  ብር2,552.57
Kz45,674.19
List Price:  Kz63,947.53
You save:  Kz18,273.33
CLP$47,160.37
List Price:  CLP$66,028.30
You save:  CLP$18,867.92
CN¥362.98
List Price:  CN¥508.21
You save:  CN¥145.22
RD$3,096.31
List Price:  RD$4,335.08
You save:  RD$1,238.77
DA6,738.75
List Price:  DA9,434.79
You save:  DA2,696.04
FJ$114.76
List Price:  FJ$160.67
You save:  FJ$45.91
Q384.53
List Price:  Q538.38
You save:  Q153.84
GY$10,421.65
List Price:  GY$14,591.14
You save:  GY$4,169.49
ISK kr7,020.59
List Price:  ISK kr9,829.39
You save:  ISK kr2,808.80
DH497.30
List Price:  DH696.26
You save:  DH198.96
L932.39
List Price:  L1,305.42
You save:  L373.03
ден2,935.20
List Price:  ден4,109.51
You save:  ден1,174.31
MOP$399.35
List Price:  MOP$559.12
You save:  MOP$159.77
N$915.30
List Price:  N$1,281.49
You save:  N$366.19
C$1,832.95
List Price:  C$2,566.27
You save:  C$733.32
रु6,909.39
List Price:  रु9,673.70
You save:  रु2,764.31
S/185.06
List Price:  S/259.11
You save:  S/74.04
K200.33
List Price:  K280.47
You save:  K80.14
SAR187.48
List Price:  SAR262.49
You save:  SAR75
ZK1,403.48
List Price:  ZK1,964.98
You save:  ZK561.50
L237.56
List Price:  L332.60
You save:  L95.04
Kč1,195.40
List Price:  Kč1,673.66
You save:  Kč478.25
Ft19,211.82
List Price:  Ft26,898.09
You save:  Ft7,686.26
SEK kr535.78
List Price:  SEK kr750.14
You save:  SEK kr214.35
ARS$52,799.70
List Price:  ARS$73,923.81
You save:  ARS$21,124.10
Bs344.18
List Price:  Bs481.88
You save:  Bs137.70
COP$206,708.77
List Price:  COP$289,408.83
You save:  COP$82,700.05
₡25,257.78
List Price:  ₡35,362.91
You save:  ₡10,105.13
L1,269.88
List Price:  L1,777.93
You save:  L508.05
₲392,483.62
List Price:  ₲549,508.48
You save:  ₲157,024.85
$U2,166.69
List Price:  $U3,033.55
You save:  $U866.85
zł198.69
List Price:  zł278.18
You save:  zł79.49
Already have an account? Log In

Transcript

Microsoft Excel we can do some of these Conditional Formatting as you can see here. So we go into Microsoft Excel, then we can highlight a cell. So let's say I highlight one column here. Okay? Okay, I can highlight the whole cells here. Then conditional formatting.

So you can highlight a cell salary, let's say rules are greater than, less than, or these are between equal to, or we can highlight our cells are using those top 10, top 10%, bottom 10 returns bottom 10% above average, you can use a data bar you can use all these are the top bar. Okay, we can also use color scale We can use our icon set. Okay, or we can set our rules here. So we can use the color scale. So far yeah, I use this one. So this is how we can do the conditional formatting.

And these are Microsoft Excel.

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.