Scribd
Upload
37 views8 pages

Conditional Formatting

Conditional formatting allows cells to be formatted automatically based on certain criteria. It can change font colors of negative values or background colors of duplicate values. Conditional formatting is useful for large datasets or values that change frequently to avoid manually reformatting cells each time. Examples shown include highlighting duplicate item quantities, below-average monthly sales, and formatting sales data by country and quarter.

Uploaded by

sayang
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
37 views8 pages

Conditional Formatting

Conditional formatting allows cells to be formatted automatically based on certain criteria. It can change font colors of negative values or background colors of duplicate values. Conditional formatting is useful for large datasets or values that change frequently to avoid manually reformatting cells each time. Examples shown include highlighting duplicate item quantities, below-average monthly sales, and formatting sales data by country and quarter.

Uploaded by

sayang
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
You are on page 1/ 8

What is excel conditional formatting ?

Conditional formatting is your way of telling excel to format all the cells that meet a
criteria in a certain way. For eg. you can use conditional formatting to change the
font color of all cells with negative values or change background color of cells with
duplicate values.

Why use conditional formatting?


Of course, you can manually change the formats of cells that meet a criteria. But
this a cumbersome and repetitive process. Especially if you have large set of values
or your values change often. That is why we use conditional formatting. To
automatically change formatting when a cell meets certain criteria.

Few Examples of Conditional Formatting


Here are 3 examples of conditional formatting.
Item Qty
Pen 81
Marker 6
Pencil 39
Paper 43
Eraser 2
Pen 95
Marker 5
Pencil 11
Paper 86
Eraser 57
Item Qty
Pen 81
Marker 6
Pencil 39
Paper 43
Eraser 2
Pen 95
Marker 5
Pencil 11
Paper 86
Eraser 57
Average Monthly Sales
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2010 27.9 36.7 42.4 54.5 62.5 67.5 72.7 75.7 66.3 55 51.2 35.9
2011 32.5 33.1 48.2 57.9 65.3 74.7 81.3 77.4 71.1 58.1 47.9 32.8
2012 29.7 36 42.3 54.3 64.5 72.3 80.2 75.3 70 57.1 51.9 43.3
2013 37.3 40.9 50.9 54.8 65.1 71 78.8 76.7 68.8 58 43.9 41.5
2014 35.1 33.9 40.1 53 62.8 72.7 79.8 74.6 67.9 60.2 45.3 38.5
2015 28.6 31.6 37.7 52.3 64 72.5 76.1 74.5 69.7 59.6 45.3 40.5
2016 29.9 23.9 38.1 54.3 68.5 71.2 78.8 79 74.5 58 52.8 50.8
2017 34.5 37.7 48.9 53.3 62.8 72.3 78.7 79.2 71.8 58.8 49.8 38.3
2018 38 41.6 39.2 57.2 61.1 72 76.8 74 70.5 64.1 46.6 33.4
2019 27.9 36.7 42.4 54.5 62.5 67.5 72.7 75.7 66.3 55 51.2 35.9
2020 32.5 33.1 48.2 57.9 65.3 74.7 81.3 77.4 71.1 58.1 47.9 32.8
2021 29.7 36 42.3 54.3 64.5 72.3 80.2 75.3 70 57.1 51.9 43.3
2022 37.3 40.9 50.9 54.8 65.1 71 78.8 76.7 68.8 58 43.9 41.5
2023 35.1 33.9 40.1 53 62.8 72.7 79.8 74.6 67.9 60.2 45.3 38.5
Item Qty
Pen 81
Marker 6
Pencil 39
Paper 43
Eraser 2
Pen 95
Marker 5
Pencil 11
Paper 86
Eraser 57
Item Qty
Pen 81
Marker 6
Pencil 39
Paper 43
Eraser 2
Pen 95
Marker 5
Pencil 11
Paper 86
Eraser 57
Item Qty
Pen 81
Marker 6
Pencil 39
Paper 43
Eraser 2
Pen 95
Marker 5
Pencil 11
Paper 86
Eraser 57
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 MALAYSIA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Smith $16,753.00 THAILAND Qtr 3
Johnson $14,808.00 SINGAPORE Qtr 4
Williams $10,644.00 MALAYSIA Qtr 2
Jones $1,390.00 MALAYSIA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 MALAYSIA Qtr 1

You might also like