Posted by admin | Posted in Uncategorized | Posted on 30-12-2008
Tags: baby, bed, condition, definition of excellent condition, excellent condition, excellent condition 27d motorhome, excellent condition definition, fender, in, kbb excellent 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
2000 Jeep Wrangler Sport – Low Miles, excellent condition, from Car Buyers of Utah – Call Big Tane
|
|
KNITTING DIGEST MARCH 2000 EXCELLENT CONDITION $1.47 |
|
|
Vans Off The Wall Classic Slip-On Plaid Excellent Pre-Owned Condition MSRP $47 $12.99 |
|
|
Vintage Polaroid One Step Camera Excellent working condition $12.99 |
|
|
Dell Latitude E6410, 2.66GHz Intel Core i5 160GB, 4GB (Excellent Condition) $400.00 |
|
|
VTG 1950′s RAYON LOOP COLLAR ROCKABILLY RICKY SHIRT (M) EXCELLENT CONDITION VLV $49.99 |
|
|
ARIAT Black Leather Sandals – size 7.5B – Excellent condition $9.99 |
|
|
VINTAGE BARLING 5194, LONDON MADE, POT STYLE PIPE, EXCELLENT CONDITION, $16.05 |
|
|
Baby Barn Owl Legend of the Guardians of Ga’Hoole Soft Plush Excellent Condition $12.85 |
|
|
ORIGINAL UNIVERSAL SAMSUNG TV DVD Remote Control Excellent condition $9.99 |
|
|
1988 ROLLING THUNDER SIDEWINDER MISSILE, EXCELLENT CONDITION!!! $2.50 |
|
|
BEAUTIFUL COTTON BUTTON DOWN TOP BY STYLE & CO. SZ S – EXCELLENT CONDITION $3.49 |
|
|
Vintage Beck’s Bier Metal Serving Tray Made Germany RED Excellent Condition Beer $15.00 |
|
|
7 VINTAGE LESNEY TOY/MODEL CARS AND TRUCKS ***Excellent condition*** $29.99 |
|
|
1981 Kenner Sea Wees Tropigals Flora and Baby Finella EXCELLENT CONDITION $24.99 |
|
|
Electro Voice RE20 Microphone Excellent Condition $242.51 |
|
|
1973 KANSAS SAMPLE LICENSE PLATE ,EXCELLENT CONDITION. $10.00 |
|
|
Penthouse Forum April 1993 in Excellent Condition $5.99 |
|
|
brand new pocketbook in excellent condition $15.00 |
|
|
Penthouse Forum March 1993 in Excellent Condition $5.99 |
|
|
Vintage Silver Plate Sauce Bowl Made in Italy EL Excellent Condition $7.49 |
|
|
Pfaltzgraff Yorktown Cream Pitcher – Excellent Condition $15.00 |
|
|
Vintage double 4/4 violin case excellent condition $74.99 |
|
|
Honda : Pilot EXL EXL DVD RES One owner! Excellent Condition – REDUCED! Delivery available! $8,499.00 |
|
|
10″ Royal Vienna 1102 dish in excellent condition -pink center $88.00 |
|
|
1988 ROLLING THUNDER SMALL YELLOW MISSILE, EXCELLENT CONDITION!!! $2.50 |
|
|
FAMILY OF 3 TRI-COLOR COLLIES- CHINA ANIMALS-VTG-Excellent Condition $3.99 |
|
|
Gymboree Hippo Striped Outfit…3-6 Mos…EXCELLENT Condition $0.99 |
|
|
Penthouse Forum January 1993 in Excellent Condition – 56 Extra Pages! $5.99 |
|
|
Yellow Box Flip Flops, Animal Print, Size 7.5, Excellent Condition! $6.74 |
|
|
ALISON MOYET Invisible 1984 UK 7″ vinyl single EXCELENT CONDITION YAZOO $6.31 |
|
|
14 KT WHITE GOLD 23.5″ LONG PREOWNED IN EXCELLENT CONDITION 4.1 GRAMS NICE $149.99 |
|
|
Penthouse Forum November 1992 in Excellent Condition $5.99 |
|
|
GORGEOUS SS WESTERN SHOW STIRRUPS-READY FOR SHOW RING! EXCELLENT CONDITION $45.00 |
|
|
YAMAHA BASS BB416 IN EXCELLENT CONDITION NO RESERVE $450.00 |
|
|
2 shirts from Talbots, excellent condition, size L/XL $9.99 |
|
|
12 volt, 6amp; DEEP-CYCLE BATTERY CHARGER, Made in USA!…excellent condition $200.00 |
|
|
1970 MISSOURI SAMPLE LICENSE PLATE ,EXCELLENT CONDITION. $10.00 |
|
|
Levi’s Jean Shorts Size 5 Jr Excellent Condition $2.99 |
|
|
Womens Plus Size Top By JMS Just My Size Size 3X Excellent Used Condition $3.00 |
