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:
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.
Questions and Answers
If you're anything like me when I first began using Microsoft Excel more than 16 years ago, then you are probably pulling your hair out struggling to get your Excel projects finished.
An in depth look at the new MMORPG from Blizzard Entertainment known as Diablo III, a long awaited release for Diablo fans.
Most small businesses take advantage of computer technology, and it certainly can make things a lot easier for everyone within the business when you do so properly. Unfortunately, there are also a number of different problems that can occur as a result of the technology that you are using.
For any restaurants, it is very important to have vigilant end to end point of sale and service. If someone is new to the business of making and serving meals, it's very important to have a clear cut observation on point to point service to sale.
Small business financial software plays a vital role in the operations of an organization especially the small enterprises. This is where you get the opportunity to keep the record of all the financial activities that are occurring in your organization.
Wireless is one of the best ways in order to get internet to a laptop or a computer, but if you want to sell wireless items in the US or Canada, you need to be sure you pass the wireless testing and you get the FCC certification to prove it.
Correcting and editing the images in Photoshop is a savior for many creative professionals. In spite of that every time you use layers and curves, you start to degrade the image data -- unless, you use adjustment layers. This Photoshop Tutorial will teach you how.
A stylish, enhancing and powerful text can do wonders to your simple text. The text effect can change the look of an ordinary boring written text and makes it more impactful and interesting. In this Photoshop Tutorial, we will learn to create powerful text effect using brushes and layer styles.
Photoshop Action is a series of tasks that you play back on a single file or a batch of files menu commands, palette options, tool actions, and so on. Sometimes, editing pictures could eat up hours especially if you are a beginner in photoshop.
Photoshop Action is a series of tasks that you play back on a single file or a batch of files menu commands, palette options, tool actions, and so on. Sometimes, editing pictures could eat up hours especially if you are a beginner in photoshop.
The layer blend modes are an effective way of blending a pattern or graphic with a three-dimensional form. By using the blend modes, the flag can be modified to respect the color and tone of the undulating silk beneath it.
Discuss this Article
