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
|
|
Nice PMI Piranha R6 Paintball Gun Marker excellent condition w/200rd hopper $55.00 |
|
|
This is a Rat Pack gun and accessory bag in excellent condition. $15.00 |
|
|
Dye I4 Invision Pro Paintball Mask, in Excellent Condition!! Ships Fast!! @@ $65.00 |
|
|
Vintage Old school 11″ Razorback III paintball pump gun Excellent condition $75.00 |
|
|
Dye I4 Invision Pro Paintball Mask, in Excellent Condition!! Ships Fast!! @@ $70.00 |
|
|
EMPIRE REACT PROTECTIVE PAINTBALL PANTS -EXCELLENT CONDITION $26.00 |
|
|
Black/Blue Dragun The One with upgrades, Excellent condition $10.50 |
|
|
Tippmann A5 Paintball Marker, Flatline barrel, accessories. Excellent condition! $15.00 |
|
|
JT PAINTBALL MASK, W/ CHIN STRAP , UNSTAINED , EXCELLENT CONDITION!! $16.80 |
|
|
PMI Piranha USP Paintball Pistol! Sidearm! Excellent Condition! Silver Metal!!!! $60.00 |
|
|
PAINTBALL * BODY BAG * BLACK ROLLING BAG * L30″ W15″ D15″ * EXCELLENT CONDITION $65.00 |
|
|
Vector Paintball Gun Air Power in Excellent Condition $300.00 |
|
|
FACEFULL Paintball Magazine Issue #32 Oct. 2005 Excellent Condition $5.00 |
|
|
FACEFULL Paintball Magazine Issue #25 January 2005 Excellent Condition $5.00 |
|
|
FACEFULL Paintball Magazine Issue #24 Nov / Dec 2004 Excellent Condition $5.00 |
|
|
BT Battle Tested WOODLAND CAMO Bandolier 6 Pack EXCELLENT CONDITION!!!!!! $20.00 |
|
|
VL Crusader paintball marker gun with brass eagle hopper excellent condition $69.00 |
|
|
Smart Parts Ion Paintball Marker With Upgrades and in Excellent condition!!! @@ $185.00 |
|
|
Yellow Mixed Model Golf Balls (Pack of 36) (Refurbished) $23.49 Perfect your golf game with these Yellow Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Yellow models in good to excellent condition. |
|
|
Orange Mixed Model Golf Balls (Pack of 36) (Refurbished) $25.49 Perfect your golf game with these Orange Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Orange models in good to excellent condition. |
|
|
Apple iPhone 4 Magenta Textured Silicone Skin Case $7.99 Made of textured silicone material, this case will protect your iPhone 4 and keep it in excellent condition. The skin case has openings to allow direct access to all the phone’s buttons and functions. |
|
|
Maxfli Noodle Mixed Model Golf Balls (Pack of 36) (Refurbished) $22.99 Perfect your golf game with these Maxfli Noodle Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Maxfli Noodle models in good to excellent condition. |
|
|
Nike Mixed Model Golf Balls (Pack of 36) (Refurbished) $22.49 Perfect your golf game with these Nike Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Nike models in good to excellent condition. |
|
|
Slazenger Mixed Model Golf Balls (Pack of 36) (Refurbished) $22.49 Perfect your golf game with these Slazenger Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Slazenger models in good to excellent condition. |
|
|
Apple iPhone 4 Red Textured Silicone Skin Case $9.49 Made of textured silicone material, this case will protect your iPhone 4 and keep it in excellent condition. The skin case has openings to allow direct access to all the phone’s buttons and functions. |
|
|
Pink Mixed Model Golf Balls (Pack of 36) (Refurbished) $24.99 Perfect your golf game with these Pink Mixed Model Golf Balls. This pack of 36 recycled/refurbished golf balls contains a mixed collection of Pink models in good to excellent condition. |
|
|
Indo Heriz Tufted Red/ Black Rug (2′1 x 3′1) $29.32 Floor rug features rich tones in red, black, ivory, gold, light blue and greyThis Heriz rug is approximately 30 years old and in excellent conditionHeriz rugs are famous among collectors for soft colors and geometric patterns |
|
|
Apple iPhone 4 White Textured Silicone Skin Case $7.99 Made of textured silicone material, this case will protect your iPhone 4 and keep it in excellent condition. The skin case has openings to allow direct access to all the phone’s buttons and functions. |
