Used Condition
Microsoft Office Conditional formatting Tricks
In this article you'll get to learn Excel formatting tips that will make your life a whole lot easier. I will primarily deal with conditional formatting and will cover its two major areas.
Highlighting Table in a Repeating Table
If you want to use conditional formatting in order to highlight data in a repeating table, you should understand that repeating tables work in a similar method as repeating sections. However, if you set a condition for a repeating table, with every row of the table an independent condition is applied.
Say for example, you want a repeating table which contains a list of customers and the third column of the table is the number of years that the customer has been with a specific company. In this case we want the to highlight customers that have been with the company over 5 years by turning the row blue, and highlight customers who have been there with the company over 10 years by turning the row green.
First of all we need to insert a repeating table:
When you are in design mode, you can start by inserting a repeating table onto the form, you'll be asked for the number of columns required you can leave it with default value 3 and hit OK.
Now we have to work on specifying the conditions for the conditional formatting:
For this you first need to select the repeating table, and then click Conditional Formatting from the Format menu. Now, in the Conditional Formatting dialog box, we need to click Add in order to add a condition. When you are in the Conditional Format dialog box, under If this condition is true, within the first drop down list you must now select the field that corresponds to the text box in the third column of the repeating table. When you reach the second drop-down list, select is greater than. Correspondingly, in the third drop down list you should first select Type a number and then key in 5. Now under, Then apply this formatting, in the Background color list you must now select the color blue and hit OK so that the first condition is saved. All you need to do now is to repeat these steps again in order to add second condition and replace 5 by 10 also select green as the background color. You can order the conditions using the Move Up and Move Down buttons in the Conditional Formatting dialog Box, to make
sure that the greater than 10 condition is on top. TIP The sequence of conditions applied is from top to bottom. Hence, in case a greater than 10 condition is on top, this condition will never be applied as anything that is greater than 10 is also greater than 5.
We can now preview and test the conditional formatting:
For this we just need to click Preview Form on the Standard toolbar. We can now add some rows to the table and start entering numbers in the third column to make sure that the conditions we specified are being applied in a correct manner.
NOTE When you type 10 it won't satisfy the greater than 10 condition, so it is suggested that we change the condition to greater than or equal to 10.
About the Author
Eli Journals is a niche online resource that helps you rev up your workplace skills and become a more productive and profitable contributor. We cater to a wide range of professionals – from workplace pros to managers to team members to leaders to graphic designers to Photoshop enthusiasts. Visit us here: www.elijournals.com
My Deep Conditioning PT1
 |
 Samsung Intensity SCH U450 Verizon Qwerty Phone USED Good Condition $29.95 Time Remaining: 23d 12h 52m Buy It Now for only: $29.95 Buy It Now |
 GAP TOP CHECK COTTON SIZE X5 TP 10 12 PERFECT CONDITION $3.92 (1 Bid) Time Remaining: 30m |
 Eb Alpha Free Board COMPLETE LONG BOARD GREAT CONDITION $95.00 (13 Bids) Time Remaining: 30m |
 Samsung SPH M900 Moment Black Sprint Smartphone Great Condition Good ESN $39.99 Time Remaining: 9d 7h 47m Buy It Now for only: $39.99 Buy It Now |
 Four winns marine seat cushion nice condition 17 18 19 20 1980s $25.00 (4 Bids) Time Remaining: 31m |
 Fair Condition Blackberry Style in Box Sprint 736 $44.99 Time Remaining: 19d 10h 57m Buy It Now for only: $44.99 Buy It Now |
 Four winns marine seat cushion nice condition 17 18 19 20 1980s $23.50 (4 Bids) Time Remaining: 31m Buy It Now for only: $49.99 Buy It Now |
 LAVERN BAKER 45ATLANTIC 1075LUCKY OLD SUN MINT CONDITION 1ST PRESSING $9.99 (2 Bids) Time Remaining: 33m |
 T Mobile Samsung SGH T339 Cellular Phone Charcoal color Excellant Condition $29.95 Time Remaining: 20d 13h 4m Buy It Now for only: $29.95 Buy It Now |
 Lot Of Four Womans Tops Size XL Excellent Used Condition $5.00 Time Remaining: 33m |
 Samsung U460 SCH 460 Intensity 2 II Verizon Phone Used Good Condition $39.89 Time Remaining: 21d 8h 57m Buy It Now for only: $39.89 Buy It Now |
 LURPAK CREAM BUTTER DISH WITHRECLINING DOUGLAS Excellent Condition $7.06 (1 Bid) Time Remaining: 34m |
 HARRY POTTER COMPLETE SET 1 7 HARDCOVER VERY GOOD CONDITION $39.95 (1 Bid) Time Remaining: 36m |
 LG Shine CU720 ATT Used Condition GSM CAMERA Phone SILVER 003 $24.99 Time Remaining: 4d 11h 30m Buy It Now for only: $24.99 Buy It Now |
 Lot Of Two Juniors Tops In Excellent Condition Size Medium One Step UpJones NY $1.00 Time Remaining: 36m |
 HTC Thunderbolt 4G LTE Verizon Phone CLEAN ESN Used Good Condition $149.95 Time Remaining: 29d 8h 27m Buy It Now for only: $149.95 Buy It Now |
 Lot Of Two Juniors Jeans In Excellent Used Condition Size One LEI Union Bay $1.00 Time Remaining: 36m |
 ACE Bible reading Paces 2nd Grade Not Used Excellent Condition 10 Paces $8.00 Time Remaining: 36m Buy It Now for only: $10.00 Buy It Now |
 Boost Mobile Samsung Prevail Galaxy Android Smart Phone Great Condition $59.99 Time Remaining: 15d 11h 31m Buy It Now for only: $59.99 Buy It Now |
 ANCHOR CREAM BUTTER DISH WITH RED ANCHOR LIMITED EDITION EXCELLENT CONDITION $7.83 Time Remaining: 38m |
 Samsung Galaxy Prevail SPH M820 Boost Mobile Smartphone Black Good Condition $48.88 Time Remaining: 26d 7h 7m Buy It Now for only: $48.88 Buy It Now |
 HARRY POTTER COMPLETE SET 1 7 HARDCOVER VERY GOOD CONDITION $39.95 Time Remaining: 41m |
 DINKY TOYS JEEP WITH IN ORIGINAL PLAYWORN CONDITION LOW START NO RESERVE $13.69 (6 Bids) Time Remaining: 41m |
 Romanian 1969 22 Training Rifle Original Replacement Bolt Used Condition $21.99 Time Remaining: 29d 10h 18m Buy It Now for only: $21.99 Buy It Now |
 Harley Davidson Mens t shirt large Gray Wilmington NC Perfect condition $7.25 (2 Bids) Time Remaining: 44m |
 Motorola V860 Barrge Camera Bluetooth Rugged Near Mint Condition Under 50 Hrs $34.99 Time Remaining: 29d 8h 5m Buy It Now for only: $34.99 Buy It Now |
 PANTECH P9020 PURSUIT ATT GREAT CONDITION 3G QWERTY PHONE GREEN $59.99 Time Remaining: 44m Buy It Now for only: $69.99 Buy It Now |
 Canda Size 20 Petite Cream Floral Summer Dress Excellent Condition $1.96 Time Remaining: 46m |
 Large 4 deshedding tool marked Furminator lightly used nice condition $15.23 Time Remaining: 5d 17h 17m Buy It Now for only: $15.23 Buy It Now |
 Vintage 1960 Tin russian russia MOTORCYCLE in great condition $99.00 Time Remaining: 47m |
 Excellent Condition Verizon Samsung Alias 2 U750 Full Keyboard Used Phone $39.95 Time Remaining: 9d 14h 27m Buy It Now for only: $39.95 Buy It Now |
 RED NYLON RUNNING MARTINGALE GOOD CONDITION $7.00 Time Remaining: 48m |
 Burberry Eden Bag Gently Used in Good Condition Nova Check $298.00 (3 Bids) Time Remaining: 50m |
 Apple iPhone 3GS 8GB Black ATT Smartphone Acceptable Condition $137.98 Time Remaining: 29d 6h 54m Buy It Now for only: $137.98 Buy It Now |
 SILVER JEANS EXCELLENT CONDITION LOW PRICE $12.99 Time Remaining: 50m |
 GREAT CONDITIONS Hitachi CP X200 LCD Projector $95.00 Time Remaining: 1d 7h 8m Buy It Now for only: $95.00 Buy It Now |
 NRG 10 EUR Hi Fi power cable with 72V DBS for amplifier in good condition 10m $5.50 (8 Bids) Time Remaining: 50m |
 4MB Micron Made in USA GENUINE GREAT CONDITION RECOMMENDED $0.99 Time Remaining: 51m |
 BlackBerry 8330 Verizon USED Good Condition Clean ESN $15.00 Time Remaining: 21d 13h 53m Buy It Now for only: $15.00 Buy It Now |
 HAWKEYE BULK VENDOR NICE CONDITION ALL ORIGINAL GLOBE 1940s $225.00 Time Remaining: 51m |
 Verizon Sharp Kin One OneM Microsoft Cell Phone USED Fair Condition $34.98 Time Remaining: 18d 17h 42m Buy It Now for only: $34.98 Buy It Now |
 HARRY POTTER COMPLETE SET 1 7 PAPERBACK VERY GOOD CONDITION $29.95 Time Remaining: 55m |
 LADIES BLACK LEATHER BECKER PURSE WALLET IN GOOD CONDITION $14.04 Time Remaining: 56m |
 Used ATT Motorola Tundra VA76R Cell Phone ATT Rugged Flip GOOD Condition GL $64.95 Time Remaining: 2d 17h 15m Buy It Now for only: $64.95 Buy It Now |
 7pc Boys Lot 6 months Summer clothes Excellent Condition $7.50 Time Remaining: 58m |
 BLOWOUT Motorola RAZR V3c NO CRACKS GOOD CONDITION READY TO BE ACTIVATED $19.99 Time Remaining: 14d 13h 16m Buy It Now for only: $19.99 Buy It Now |
 Genuine INDIANA License Plate hard to find BUS 1987 near new condition $6.50 Time Remaining: 1h 1m Buy It Now for only: $15.00 Buy It Now |
 VINTAGE BRASS DESKTOP INKWELL MODELLED AS HMS VICTORY EX CONDITION $15.67 Time Remaining: 1h 2m |
 Excellent Condition Verizon Samsung Reality U820 Black Slider Full Keyboard Used $59.95 Time Remaining: 15d 13h 28m Buy It Now for only: $59.95 Buy It Now |
 Limited Edition Princess Collectors Edition TROLL Dolls Excellent Condition $6.35 (4 Bids) Time Remaining: 1h 3m |
 Lost Planet 2 List Price: Sale Price: $13.99 You save: $16.00 (53%)  Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product DescriptionThe next installment in the popular Lost Planet action series, Lost Planet 2 is a third-person shooter which continues the story of humanity's futuristic struggles and attempts at colonization on the planet E...  |
 Katamari Forever List Price: Sale Price: $15.99 You save: $14.00 (47%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionWhen the King of All Cosmos bumps his head and loses his memory, the Prince and his cousins design a RoboKing to replace him. But the situation goes terribly awry when the RoboKing goes out of control and destroys all the stars... |
 Final Fantasy XIII List Price: Sale Price: $30.63 You save: $9.36 (23%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionFinal Fantasy XIII Xbox 360 |
 Burnout Legends Sale Price: $9.99 Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionBurnout: Legends takes the most explosive moments of the popular Burnout series of racing games, mashes themtogether and adds some new surprises -- giving you the best racing experience to come out for the PSP... |
 Sega Bass Fishing List Price: Sale Price: $12.50 You save: $17.45 (58%) Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product DescriptionThe sun is out, the fish are biting and your tackle box is filled with 20 different types of lures. With content created exclusively for the Wii, you'll motor out, find your favorite fishing hole, cast off using the Wii Remote and snag one of four types of bass... |
 F1: 2010 List Price: Sale Price: $52.99 You save: $7.00 (12%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionRip through 19 tracks Synopsis The glamour. The exhilaration. The intensity. The speed. With drivers cruising a smooth 200mph — minimum — and cutthroat teams carving out dynasties of speed, Formula One is the most elite racing circle in the world and the most thrilling motorsport tearing up the tracks... |
 Logitech G13 Programmable Gameboard with LCD Display List Price: Sale Price: $72.04 You save: $7.95 (10%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionThe Logitech G13 advanced gameboard gives you game-changing comfort and control. Naturally contoured design follows the natural shape of your hand and fingers for increased comfort during long sessions... |
 Deer Drive List Price: Sale Price: $13.87 You save: $6.12 (31%) Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product DescriptionDeer Drive meshes hunting simulation with arcade style pick-up-and-play action and pacing for an exciting gaming experience. Deer Drive is the first deer hunting game that features two-player simultaneous play... |
 F1: 2010 List Price: Sale Price: $52.99 You save: $7.00 (12%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionRip through 19 tracks Synopsis The glamour. The exhilaration. The intensity. The speed. With drivers cruising a smooth 200mph — minimum — and cutthroat teams carving out dynasties of speed, Formula One is the most elite racing circle in the world and the most thrilling motorsport tearing up the tracks... |
 Deer Drive with Blaster Hunting Bundle Sale Price: $19.99 Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionDeer Drive meshes hunting simulation with arcade style pick-up-and-play action and pacing for an exciting gaming experience. Deer Drive is the first deer hunting game that features two-player simultaneous play... |
|
|
Predictive Maintenance of Pumps Using Condition Monitoring $209.27 Description not available. |
