Scribd
Upload
17 views27 pages

Conditional Formating

The document provides an overview of Conditional Formatting in Excel, detailing various rules and methods for applying formatting based on logical tests that yield TRUE or FALSE results. It covers built-in features such as Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets, along with keyboard shortcuts for managing rules. Additionally, it includes examples of using formulas to format cells based on specific criteria, such as values exceeding a threshold or containing certain text.

Uploaded by

Olgica M
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
17 views27 pages

Conditional Formating

The document provides an overview of Conditional Formatting in Excel, detailing various rules and methods for applying formatting based on logical tests that yield TRUE or FALSE results. It covers built-in features such as Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets, along with keyboard shortcuts for managing rules. Additionally, it includes examples of using formulas to format cells based on specific criteria, such as values exceeding a threshold or containing certain text.

Uploaded by

Olgica M
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/ 27

Topics:

1 Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting.
Built-in Conditional Formatting
Highlight Cell Rules for different data types and comparative operators
2 Type in textbox: Greater than 1000
3 Type in textbox: Contains "Fun"
4 Link textbox to cell: Greater than 1000
5 Link textbox to cell: Contains "Fun"
Top Bottom Rules for numbers
6 Top 3
7 Above Average
Data Bars = Ranks the numbers with length of bar
8 Data Bar on top of numbers
9 Data bars in cell next to numbers. Also RANDBETWEEN Conditional Formatting.
10 Manage Rules dialog Box
11 Manage Rule dialog box keyboard: Alt, O, D
12 Color scales = Ranks number by color.
13 Fun with CF, RAND, and Bubble Chart
Icons = divides the numbers into 3, 4, or 5 groups (Top, middle, bottom)
14 Arrow Icons on top of numbers
15 Arrow Icons next to numbers
16 Logical Formulas:
Any formula that comes out TRUE or FALSE
TRUE = get Formatting. FALSE = Not get Formatting.
FALSE = Not get Formatting.
Array Formulas work in Conditional Formatting dialog box
Errors are ignored
Any non-zero number = TRUE
Zero = FALSE
This means the full list for what the formula can evaluate to and apply formatting is:
Get Formatting = TRUE or Any Non-Zero Number
NOT Get Formatting = FALSE or Zero or Error
Formula Examples:
17 Format number less than zero: 3 methods
18 Format Actual when Actual Exceeds Budgeted: 2 methods
19 Keyboard for New Format Rule dialog box: Alt, O, D, Alt + N or Alt, H, L, N
20 Keyboard to delete rule: Alt, O, D, D, Enter
21 Clear Content and CF still remains
22 Format cell based on a different cell's value: Format Net Sales based on date
23 Sort and CF will adjust
24 Format cell based on a different cell's value: Format Net Sales based on Invoice number
25 Format whole row based on date
26 Format whole row based on Invoice number
27 Format Row when Actual Exceeds Budgeted
28 Format whole column
Conditional Formatting to cells: A logical test that comes out TRUE or FALSE
TRUE = the cell gets the formatting
FALSE = the cell does NOT get the formatting
Highlight Cell Rules for different data types and comparative operators

Greater than 1000


Contains Fun

Date Product Net Sales Cost Date Product


1/1/2013 Quad $1,232.44 $591.58 1/1/2013 Quad
1/2/2013 V-Rang $1,000.00 $212.08 1/2/2013 V-Rang
1/2/2013 Carlota $357.50 $193.06 1/2/2013 Carlota
1/2/2013 Darnell $1,957.60 $1,037.55 1/2/2013 Darnell
1/3/2013 Quad $561.68 $303.31 1/3/2013 Quad
1/3/2013 Fun Fly $1,980.00 $990.00 1/3/2013 Fun Fly
1/4/2013 Quad $2,772.00 $1,469.16 1/4/2013 Quad
1/5/2013 Quad $4,536.00 $2,358.72 1/5/2013 Quad
1/5/2013 Bellen $503.10 $251.56 1/5/2013 Bellen
1/5/2013 Fun Rang $3,938.40 $1,890.40 1/5/2013 Fun Rang
1/5/2013 Bellen $464.96 $237.12 1/5/2013 Bellen
Criteria:
Net Sales Product
1000 Fun

Invoice Date Company Product Net Sales Cost


659439 1/1/2013 Gel Booms Quad $1,232.44 $591.58
659440 1/2/2013 Tri Fly V-Rang $451.20 $212.08
659440 1/2/2013 Gel Booms Carlota $357.50 $193.06
659440 1/2/2013 Tri Fly Darnell $1,957.60 $1,037.55
659441 1/3/2013 Gel Booms Quad $561.68 $303.31
659441 1/3/2013 Gel Booms Carlota $1,980.00 $990.00
659442 1/4/2013 Gel Booms Quad $2,772.00 $1,469.16
659443 1/5/2013 Gel Booms Quad $4,536.00 $2,358.72
659443 1/5/2013 Gel Booms Bellen $503.10 $251.56
659444 1/5/2013 Tri Fly Darnell $3,938.40 $1,890.40
659444 1/5/2013 Gel Booms Bellen $464.96 $237.12
659445 1/5/2013 Gel Booms Carlota $1,650.00 $792.00
659445 1/5/2013 Colorad Boom Yanaki $114.00 $55.86
659446 1/5/2013 Colorad Boom Mt. Fun $1,008.72 $504.36
659446 1/5/2013 Colorad Boom Yanaki $730.20 $365.10
659446 1/5/2013 Gel Booms Sunset $3,174.00 $1,713.96
659446 1/5/2013 Gel Booms Quad $2,304.00 $1,082.88
659446 1/5/2013 Gel Booms Quad $2,744.98 $1,317.61
659446 1/5/2013 Gel Booms Quad $3,361.20 $1,579.75
659447 1/5/2013 Colorad Boom Aspen $48.48 $25.20
659447 1/5/2013 Colorad Boom Crest $1,664.00 $881.92
659448 1/6/2013 Colorad Boom Yanaki $670.40 $355.28
659449 1/7/2013 Gel Booms Sunset $611.42 $324.06
659450 1/8/2013 Gel Booms Quad $962.88 $510.32
659451 1/9/2013 Tri Fly V-Rang $203.04 $95.40
659451 1/9/2013 Tri Fly Fun Fly $256.20 $140.90
659452 1/10/2013 Colorad Boom Aspen $1,360.00 $639.20
659453 1/10/2013 Tri Fly FastFly $4,309.20 $2,326.95
659453 1/10/2013 Tri Fly V-Rang $241.28 $132.72
659454 1/11/2013 Colorad Boom Mt. Fun $1,672.00 $819.28
659455 1/11/2013 Gel Booms Bellen $2,631.60 $1,421.04
659455 1/11/2013 Colorad Boom Yanaki $368.72 $188.04
659455 1/11/2013 Colorad Boom Aspen $1,632.00 $767.04
659455 1/11/2013 Colorad Boom Yanaki $670.40 $341.92
659455 1/11/2013 Tri Fly Fun Fly $39.04 $19.52
659455 1/11/2013 Tri Fly V-Rang $394.80 $197.40
659455 1/11/2013 Colorad Boom Yanaki $219.06 $118.30
659455 1/11/2013 Gel Booms Quad $200.60 $106.32
659456 1/12/2013 Gel Booms Sunset $1,150.00 $552.00
659456 1/12/2013 Colorad Boom Mt. Fun $495.00 $237.60
659456 1/12/2013 Tri Fly Fun Fly $51.24 $27.16
659457 1/12/2013 Tri Fly Fun Fly $40.26 $21.33
659457 1/12/2013 Colorad Boom Aspen $60.60 $28.50
659457 1/12/2013 Colorad Boom Yanaki $2,394.00 $1,292.76
659458 1/13/2013 Tri Fly Fun Fly $207.36 $107.82
659458 1/13/2013 Tri Fly FastFly $1,316.70 $618.84
659459 1/14/2013 Tri Fly Fun Fly $183.00 $95.20
mes out TRUE or FALSE.

Net Sales Cost 1 Type in textbox: Greater than 1000


$1,232.44 $591.58 2 Type in textbox: Contains "Fun"
$1,000.00 $212.08 3 Link textbox to cell: Greater than 1000
$357.50 $193.06 4 Link textbox to cell: Contains "Fun"
$1,957.60 $1,037.55
$561.68 $303.31
$1,980.00 $990.00
$2,772.00 $1,469.16
$4,536.00 $2,358.72
$503.10 $251.56
$3,938.40 $1,890.40
$464.96 $237.12
Top Bottom Rules for numbers
Top 3

Date Product Net Sales Cost Date Product


1/1/2013 Quad $1,232.44 $591.58 1/1/2013 Quad
1/2/2013 V-Rang $1,000.00 $212.08 1/2/2013 V-Rang
1/2/2013 Carlota $357.50 $193.06 1/2/2013 Carlota
1/2/2013 Darnell $1,957.60 $1,037.55 1/2/2013 Darnell
1/3/2013 Quad $561.68 $303.31 1/3/2013 Quad
1/3/2013 Fun Fly $1,980.00 $990.00 1/3/2013 Fun Fly
1/4/2013 Quad $2,772.00 $1,469.16 1/4/2013 Quad
1/5/2013 Quad $4,536.00 $2,358.72 1/5/2013 Quad
1/5/2013 Bellen $503.10 $251.56 1/5/2013 Bellen
1/5/2013 Fun Rang $3,938.40 $1,890.40 1/5/2013 Fun Rang
1/5/2013 Bellen $464.96 $237.12 1/5/2013 Bellen
Above Average

Net Sales Cost 1 Top 3


$1,232.44 $591.58 2 Above Average
$1,000.00 $212.08
$357.50 $193.06
$1,957.60 $1,037.55
$561.68 $303.31
$1,980.00 $990.00
$2,772.00 $1,469.16
$4,536.00 $2,358.72
$503.10 $251.56
$3,938.40 $1,890.40
$464.96 $237.12
Data Bars = Ranks the numbers with length of bar
Data Bar on top of numbers
Data bars in cell next to numbers. Also RANDBETWEEN Conditional Formatting.
Manage Rules dialog Box
Manage Rule dialog box keyboard: Alt, O, D

Grades Grades Chart


19 19
76 76
23 23
92 92
73 73
92 92
36 36
59 59
81 81
98 98
NDBETWEEN Conditional Formatting.
Color scales = Ranks number by color.
Fun with CF, RAND, and Bubble Chart

Grades
19
76
23
92
73
92
36
59
81
98
Icons = divides the numbers into 3, 4, or 5 groups (Top, middle, bottom)
Arrow Icons on top of numbers
Arrow Icons next to numbers

Grades Grades Category


19 19
76 76
23 23
92 92
73 73
92 92
36 36
59 59
81 81
98 98
13 Logical Formulas:
Any formula that comes out TRUE or FALSE
TRUE = get Formatting. FALSE = Not get Formatting.
FALSE = Not get Formatting.
Array Formulas work in Conditional Formatting dailog box
Errors are ignored
Any non-zero number = TRUE
Zero = FALSE
This means the full list for what the formula can evaluate to and apply formatting is:
Get Formatting = TRUE or Any Non-Zero Number
NOT Get Formatting = FALSE or Zero or Error
Format number less than zero: 3 methods

Stock Buy Price Price today Quantity Profit


GOOG $755.00 $1,015.00 700 182000
GE $22.00 $29.10 2200 15620
KO $36.00 $37.00 300 300
MSFT $36.00 $36.00 4000 0
KK $51.00 $42.00 700 -6300
SW $31.00 $17.00 400 -5600

OR:

Stock Buy Price Price today Quantity Profit Value:


GOOG $755.00 $1,015.00 700 182000 0
GE $22.00 $29.10 2200 15620
KO $36.00 $37.00 300 300
MSFT $36.00 $36.00 4000 0
KK $51.00 $42.00 700 -6300
SW $31.00 $17.00 400 -5600

OR:

Stock Buy Price Price today Quantity Profit Value:


GOOG $755.00 $1,015.00 700 182000 0
GE $22.00 $29.10 2200 15620
KO $36.00 $37.00 300 300
MSFT $36.00 $36.00 4000 0
KK $51.00 $42.00 700 -6300
SW $31.00 $17.00 400 -5600
Format Actual when Actual Exceeds Budgeted: 2 methods

Expense Budgeted Amount Actual


Rent $15,000.00 $15,000.00 Greater than
Operations $195,500.00 $215,809.25
Administration $59,800.00 $59,852.11
COGS $356,500.00 $345,089.25
Wage $159,000.00 $149,087.25
Depr $105,000.00 $105,000.00
Other $7,500.00 $65,809.25

Expense Budgeted Amount Actual Logical


Rent $15,000.00 $15,000.00
Operations $195,500.00 $215,809.25
Administration $59,800.00 $59,852.11
COGS $356,500.00 $345,089.25
Wage $159,000.00 $149,087.25
Depr $105,000.00 $105,000.00
Other $7,500.00 $65,809.25
Format cell based on a different cell's value: Format Net Sales based on date

Date
1/5/2013

Invoice Date Company Product Net Sales Cost


659439 1/1/2013 Gel Booms Quad $1,232.44 $591.58
659440 1/2/2013 Tri Fly Darnell $1,957.60 $1,037.55
659440 1/2/2013 Tri Fly V-Rang $451.20 $212.08
659440 1/2/2013 Gel Booms Carlota $357.50 $193.06
659441 1/3/2013 Gel Booms Carlota $1,980.00 $990.00
659441 1/3/2013 Gel Booms Quad $561.68 $303.31
659442 1/4/2013 Gel Booms Quad $2,772.00 $1,469.16
659443 1/5/2013 Gel Booms Quad $4,536.00 $2,358.72
659443 1/5/2013 Gel Booms Bellen $503.10 $251.56
659444 1/5/2013 Tri Fly Darnell $3,938.40 $1,890.40
659444 1/5/2013 Gel Booms Bellen $464.96 $237.12
659445 1/5/2013 Gel Booms Carlota $1,650.00 $792.00
659445 1/5/2013 Colorad Boom Yanaki $114.00 $55.86
659446 1/5/2013 Gel Booms Quad $3,361.20 $1,579.75
659446 1/5/2013 Gel Booms Sunset $3,174.00 $1,713.96
659446 1/5/2013 Gel Booms Quad $2,744.98 $1,317.61
659446 1/5/2013 Gel Booms Quad $2,304.00 $1,082.88
659446 1/5/2013 Colorad Boom Mt. Fun $1,008.72 $504.36
659446 1/5/2013 Colorad Boom Yanaki $730.20 $365.10
659447 1/5/2013 Colorad Boom Crest $1,664.00 $881.92
659447 1/5/2013 Colorad Boom Aspen $48.48 $25.20
659448 1/6/2013 Colorad Boom Yanaki $670.40 $355.28
659449 1/7/2013 Gel Booms Sunset $611.42 $324.06
659450 1/8/2013 Gel Booms Quad $962.88 $510.32
659451 1/9/2013 Tri Fly Fun Fly $256.20 $140.90
659451 1/9/2013 Tri Fly V-Rang $203.04 $95.40
659452 1/10/2013 Colorad Boom Aspen $1,360.00 $639.20
659453 1/10/2013 Tri Fly FastFly $4,309.20 $2,326.95
659453 1/10/2013 Tri Fly V-Rang $241.28 $132.72
659454 1/11/2013 Colorad Boom Mt. Fun $1,672.00 $819.28
659455 1/11/2013 Gel Booms Bellen $2,631.60 $1,421.04
659455 1/11/2013 Colorad Boom Aspen $1,632.00 $767.04
659455 1/11/2013 Colorad Boom Yanaki $670.40 $341.92
659455 1/11/2013 Tri Fly V-Rang $394.80 $197.40
659455 1/11/2013 Colorad Boom Yanaki $368.72 $188.04
659455 1/11/2013 Colorad Boom Yanaki $219.06 $118.30
659455 1/11/2013 Gel Booms Quad $200.60 $106.32
659455 1/11/2013 Tri Fly Fun Fly $39.04 $19.52
659456 1/12/2013 Gel Booms Sunset $1,150.00 $552.00
659456 1/12/2013 Colorad Boom Mt. Fun $495.00 $237.60
659456 1/12/2013 Tri Fly Fun Fly $51.24 $27.16
659457 1/12/2013 Colorad Boom Yanaki $2,394.00 $1,292.76
659457 1/12/2013 Colorad Boom Aspen $60.60 $28.50
659457 1/12/2013 Tri Fly Fun Fly $40.26 $21.33
659458 1/13/2013 Tri Fly FastFly $1,316.70 $618.84
659458 1/13/2013 Tri Fly Fun Fly $207.36 $107.82
659459 1/14/2013 Tri Fly Fun Fly $183.00 $95.20
Format cell based on a different cell's value: Format Net Sales based on Invoice number

Invoice
659440

Invoice Date Company Product Net Sales Cost


659439 1/1/2013 Gel Booms Quad $1,232.44 $591.58
659440 1/2/2013 Tri Fly V-Rang $451.20 $212.08
659440 1/2/2013 Gel Booms Carlota $357.50 $193.06
659440 1/2/2013 Tri Fly Darnell $1,957.60 $1,037.55
659441 1/3/2013 Gel Booms Quad $561.68 $303.31
659441 1/3/2013 Gel Booms Carlota $1,980.00 $990.00
659442 1/4/2013 Gel Booms Quad $2,772.00 $1,469.16
659443 1/5/2013 Gel Booms Quad $4,536.00 $2,358.72
659443 1/5/2013 Gel Booms Bellen $503.10 $251.56
659444 1/5/2013 Tri Fly Darnell $3,938.40 $1,890.40
659444 1/5/2013 Gel Booms Bellen $464.96 $237.12
659445 1/5/2013 Gel Booms Carlota $1,650.00 $792.00
659445 1/5/2013 Colorad Boom Yanaki $114.00 $55.86
659446 1/5/2013 Colorad Boom Mt. Fun $1,008.72 $504.36
659446 1/5/2013 Colorad Boom Yanaki $730.20 $365.10
659446 1/5/2013 Gel Booms Sunset $3,174.00 $1,713.96
659446 1/5/2013 Gel Booms Quad $2,304.00 $1,082.88
659446 1/5/2013 Gel Booms Quad $2,744.98 $1,317.61
659446 1/5/2013 Gel Booms Quad $3,361.20 $1,579.75
659447 1/5/2013 Colorad Boom Aspen $48.48 $25.20
659447 1/5/2013 Colorad Boom Crest $1,664.00 $881.92
659448 1/6/2013 Colorad Boom Yanaki $670.40 $355.28
659449 1/7/2013 Gel Booms Sunset $611.42 $324.06
659450 1/8/2013 Gel Booms Quad $962.88 $510.32
659451 1/9/2013 Tri Fly V-Rang $203.04 $95.40
659451 1/9/2013 Tri Fly Fun Fly $256.20 $140.90
659452 1/10/2013 Colorad Boom Aspen $1,360.00 $639.20
659453 1/10/2013 Tri Fly FastFly $4,309.20 $2,326.95
659453 1/10/2013 Tri Fly V-Rang $241.28 $132.72
659454 1/11/2013 Colorad Boom Mt. Fun $1,672.00 $819.28
659455 1/11/2013 Gel Booms Bellen $2,631.60 $1,421.04
659455 1/11/2013 Colorad Boom Yanaki $368.72 $188.04
659455 1/11/2013 Colorad Boom Aspen $1,632.00 $767.04
659455 1/11/2013 Colorad Boom Yanaki $670.40 $341.92
659455 1/11/2013 Tri Fly Fun Fly $39.04 $19.52
659455 1/11/2013 Tri Fly V-Rang $394.80 $197.40
659455 1/11/2013 Colorad Boom Yanaki $219.06 $118.30
659455 1/11/2013 Gel Booms Quad $200.60 $106.32
659456 1/12/2013 Gel Booms Sunset $1,150.00 $552.00
659456 1/12/2013 Colorad Boom Mt. Fun $495.00 $237.60
659456 1/12/2013 Tri Fly Fun Fly $51.24 $27.16
659457 1/12/2013 Tri Fly Fun Fly $40.26 $21.33
659457 1/12/2013 Colorad Boom Aspen $60.60 $28.50
659457 1/12/2013 Colorad Boom Yanaki $2,394.00 $1,292.76
659458 1/13/2013 Tri Fly Fun Fly $207.36 $107.82
659458 1/13/2013 Tri Fly FastFly $1,316.70 $618.84
659459 1/14/2013 Tri Fly Fun Fly $183.00 $95.20
Format whole row based on date

Date
1/5/2013

Invoice Date Company Product Net Sales Cost Invoice


659455 1/11/2013 Tri Fly Fun Fly $39.04 $19.52
659457 1/12/2013 Tri Fly Fun Fly $40.26 $21.33
659447 1/5/2013 Colorad Boom Aspen $48.48 $25.20
659456 1/12/2013 Tri Fly Fun Fly $51.24 $27.16
659457 1/12/2013 Colorad Boom Aspen $60.60 $28.50
659445 1/5/2013 Colorad Boom Yanaki $114.00 $55.86
659459 1/14/2013 Tri Fly Fun Fly $183.00 $95.20
659451 1/9/2013 Tri Fly V-Rang $203.04 $95.40
659455 1/11/2013 Gel Booms Quad $200.60 $106.32
659458 1/13/2013 Tri Fly Fun Fly $207.36 $107.82
659455 1/11/2013 Colorad Boom Yanaki $219.06 $118.30
659453 1/10/2013 Tri Fly V-Rang $241.28 $132.72
659451 1/9/2013 Tri Fly Fun Fly $256.20 $140.90
659455 1/11/2013 Colorad Boom Yanaki $368.72 $188.04
659440 1/2/2013 Gel Booms Carlota $357.50 $193.06
659455 1/11/2013 Tri Fly V-Rang $394.80 $197.40
659440 1/2/2013 Tri Fly V-Rang $451.20 $212.08
659444 1/5/2013 Gel Booms Bellen $464.96 $237.12
659456 1/12/2013 Colorad Boom Mt. Fun $495.00 $237.60
659443 1/5/2013 Gel Booms Bellen $503.10 $251.56
659441 1/3/2013 Gel Booms Quad $561.68 $303.31
659449 1/7/2013 Gel Booms Sunset $611.42 $324.06
659455 1/11/2013 Colorad Boom Yanaki $670.40 $341.92
659448 1/6/2013 Colorad Boom Yanaki $670.40 $355.28
659446 1/5/2013 Colorad Boom Yanaki $730.20 $365.10
659446 1/5/2013 Colorad Boom Mt. Fun $1,008.72 $504.36
659450 1/8/2013 Gel Booms Quad $962.88 $510.32
659456 1/12/2013 Gel Booms Sunset $1,150.00 $552.00
659439 1/1/2013 Gel Booms Quad $1,232.44 $591.58
659458 1/13/2013 Tri Fly FastFly $1,316.70 $618.84
659452 1/10/2013 Colorad Boom Aspen $1,360.00 $639.20
659455 1/11/2013 Colorad Boom Aspen $1,632.00 $767.04
659445 1/5/2013 Gel Booms Carlota $1,650.00 $792.00
659454 1/11/2013 Colorad Boom Mt. Fun $1,672.00 $819.28
659447 1/5/2013 Colorad Boom Crest $1,664.00 $881.92
659441 1/3/2013 Gel Booms Carlota $1,980.00 $990.00
659440 1/2/2013 Tri Fly Darnell $1,957.60 $1,037.55
659446 1/5/2013 Gel Booms Quad $2,304.00 $1,082.88
659457 1/12/2013 Colorad Boom Yanaki $2,394.00 $1,292.76
659446 1/5/2013 Gel Booms Quad $2,744.98 $1,317.61
659455 1/11/2013 Gel Booms Bellen $2,631.60 $1,421.04
659442 1/4/2013 Gel Booms Quad $2,772.00 $1,469.16
659446 1/5/2013 Gel Booms Quad $3,361.20 $1,579.75
659446 1/5/2013 Gel Booms Sunset $3,174.00 $1,713.96
659444 1/5/2013 Tri Fly Darnell $3,938.40 $1,890.40
659453 1/10/2013 Tri Fly FastFly $4,309.20 $2,326.95
659443 1/5/2013 Gel Booms Quad $4,536.00 $2,358.72
Date Company Product Net Sales Cost
Format whole row based on Invoice number

Invoice
659440

Invoice Date Company Product Net Sales Cost


659447 1/5/2013 Colorad Boom Aspen $48.48 $25.20
659452 1/10/2013 Colorad Boom Aspen $1,360.00 $639.20
659455 1/11/2013 Colorad Boom Aspen $1,632.00 $767.04
659457 1/12/2013 Colorad Boom Aspen $60.60 $28.50
659443 1/5/2013 Gel Booms Bellen $503.10 $251.56
659444 1/5/2013 Gel Booms Bellen $464.96 $237.12
659455 1/11/2013 Gel Booms Bellen $2,631.60 $1,421.04
659440 1/2/2013 Gel Booms Carlota $357.50 $193.06
659441 1/3/2013 Gel Booms Carlota $1,980.00 $990.00
659445 1/5/2013 Gel Booms Carlota $1,650.00 $792.00
659447 1/5/2013 Colorad Boom Crest $1,664.00 $881.92
659440 1/2/2013 Tri Fly Darnell $1,957.60 $1,037.55
659444 1/5/2013 Tri Fly Darnell $3,938.40 $1,890.40
659453 1/10/2013 Tri Fly FastFly $4,309.20 $2,326.95
659458 1/13/2013 Tri Fly FastFly $1,316.70 $618.84
659451 1/9/2013 Tri Fly Fun Fly $256.20 $140.90
659455 1/11/2013 Tri Fly Fun Fly $39.04 $19.52
659456 1/12/2013 Tri Fly Fun Fly $51.24 $27.16
659457 1/12/2013 Tri Fly Fun Fly $40.26 $21.33
659458 1/13/2013 Tri Fly Fun Fly $207.36 $107.82
659459 1/14/2013 Tri Fly Fun Fly $183.00 $95.20
659446 1/5/2013 Colorad Boom Mt. Fun $1,008.72 $504.36
659454 1/11/2013 Colorad Boom Mt. Fun $1,672.00 $819.28
659456 1/12/2013 Colorad Boom Mt. Fun $495.00 $237.60
659439 1/1/2013 Gel Booms Quad $1,232.44 $591.58
659441 1/3/2013 Gel Booms Quad $561.68 $303.31
659442 1/4/2013 Gel Booms Quad $2,772.00 $1,469.16
659443 1/5/2013 Gel Booms Quad $4,536.00 $2,358.72
659446 1/5/2013 Gel Booms Quad $2,304.00 $1,082.88
659446 1/5/2013 Gel Booms Quad $2,744.98 $1,317.61
659446 1/5/2013 Gel Booms Quad $3,361.20 $1,579.75
659450 1/8/2013 Gel Booms Quad $962.88 $510.32
659455 1/11/2013 Gel Booms Quad $200.60 $106.32
659446 1/5/2013 Gel Booms Sunset $3,174.00 $1,713.96
659449 1/7/2013 Gel Booms Sunset $611.42 $324.06
659456 1/12/2013 Gel Booms Sunset $1,150.00 $552.00
659440 1/2/2013 Tri Fly V-Rang $451.20 $212.08
659451 1/9/2013 Tri Fly V-Rang $203.04 $95.40
659453 1/10/2013 Tri Fly V-Rang $241.28 $132.72
659455 1/11/2013 Tri Fly V-Rang $394.80 $197.40
659445 1/5/2013 Colorad Boom Yanaki $114.00 $55.86
659446 1/5/2013 Colorad Boom Yanaki $730.20 $365.10
659448 1/6/2013 Colorad Boom Yanaki $670.40 $355.28
659455 1/11/2013 Colorad Boom Yanaki $368.72 $188.04
659455 1/11/2013 Colorad Boom Yanaki $670.40 $341.92
659455 1/11/2013 Colorad Boom Yanaki $219.06 $118.30
659457 1/12/2013 Colorad Boom Yanaki $2,394.00 $1,292.76
Format Row when Actual Exceeds Budgeted

Expense Budgeted Amount Actual


Rent $15,000.00 $15,000.00
Operations $195,500.00 $215,809.25
Administration $59,800.00 $59,852.11
COGS $356,500.00 $345,089.25
Wage $159,000.00 $149,087.25
Depr $105,000.00 $105,000.00
Other $7,500.00 $65,809.25
Format whole column

Month May

Jan Feb Mar Apr May Jun


244 605 596 116 970 170
589 385 959 778 1067 419
565 929 685 606 497 591
704 355 1114 686 678 1121
1118 1023 733 998 174 123
1045 1162 819 877 945 1106
681 121 652 993 214 448
666 627 1188 817 530 344
1030 121 384 965 734 1188
645 773 115 362 804 730
697 300 866 377 1184 789

You might also like