Conditional Formatting Demo

Turn on conditional formatting     Turn off conditional formatting

Key
Red = 0 - $250,000
Orange = $250,000 - $500,000
Yellow = $500,000 - $750,000
Green = $750,000 and up

Customer # Customer Name Salesman Country YTD Sales ($)
100007 A-1 Cycle City Amy Schilling United States 840677
100004 A/B Cycle Shoppe Rick Sterling United States 700136
100062 Accessory Zone Sally Peterson United States 686420
100005 Ace Hardware Sal Stangarone United States 548345
102053 Action Bikes Scott Carlson United Kingdom 123894
100031 Advanced Bicycles Rick Sterling United States 548340
102004 Aires Cycles Patricia Renolds Argentina 700136
100100 All Weather Cycles Rick Sterling United States 540339
102036 Alton Bicycles Michael Coleman Korea 229202
101051 Amardeep Cycles Brian Kurtzman India 456440
100022 Ames Supplies Inc. Rick Sterling United States 402046
100002 AAM-Equipto Bike Sales Sally Peterson United States 395102
100003 ABCO Corporation Amy Schilling United States 582056
101032 B.O.C Scott Carlson Germany 920250
100008 Bernard's Schwinn Cyclery Sal Stangarone United States 589502
100038 Bicycle Barn Amy Schilling United States 925010
101002 Bicycle Company e.U Scott Carlson Austria 395102
101022 Bike & Cicli Scott Carlson Switzerland 402046
101068 Bike Brasil Patricia Renolds Brazil 454543
101018 Bike Center Scott Carlson Switzerland 948100
101026 Bike Dream Scott Carlson Portugal 454534
102054 Bike Fix Scott Carlson United Kingdom 454404
101062 Bike Hire Ireland Scott Carlson Ireland 686420