Saturday, July 26, 2008

Using conditional formatting in excel

Conditional formating helps you make the excel cells behave in a different way according your requirements you desire. For example you can change the cell background to red if you enter text as red or the moment you enter text as red the font color changes to red. You can play with excel you can do lot of things in excel and more over conditional formating which help you create alerts also autmatic barcharts inside the cells instead of using bar charts. If you need help regarding such formats feel free to write to us @


Excel's conditional formatting feature (available in Excel 97 or later) offers an easy way to apply special formatting to cells if a particular condition is met. This feature is even more useful when you understand how to use a formula in your conditional formatting specification.
The worksheet below shows student grades on two tests. Conditional formatting highlights students who scored higher on the second test. This formatting is dynamic; if you change the test scores, the formatting adjusts automatically.

To apply conditional formatting, select range A2:C15 and choose Format, Conditional Formatting. The Conditional Formatting dialog box will appear with two input boxes. In the first box, choose Formula Is, press Tab, and enter the following formula: =$C2>$B2
Click Format and choose a format to distinguish the cells (the example uses background shading). Click OK, and the formatting will be applied.
The conditional formatting formula is evaluated for each cell in the range. The trick here is to use mixed cell references (the column references are absolute, but the row references are relative). To see how this works, activate any cell within the range and choose Format, Conditional Formatting so you can examine the conditional formatting formula for that cell. You'll find that cell A7, for example, uses this formula:=$C7>$B7.

Thanks to

No comments:

Post a Comment

Your Comment Please!