There was an error in this gadget

Saturday, April 12, 2008

MS-EXCEL TIP(conditional change of "color")

Conditional Formatting
Conditional formatting permits the user to apply special formatting settings that take
effect when the contents of the cell meet specified conditions. For instance, if there is a
loss under a particular head, you intend to colour it red so that it immediately catches
your attention. Similarly, you may like to colour your balance sheet totals to blue if they
do not tally. One very practical tip is to combine the ISERROR function with the
Conditional Formatting feature to hide errors. What is effectively done is that the font
and the background is set to the same color if the cell contains an error.
􀂾 Select the range of cells for which the formatting is desired
􀂾 Choose Format -> Conditional Formatting
􀂾 Allows different forms of formatting based on the cell contents
􀂾 Maximum of 3 different conditions can be specified
􀂾 To suppress errors, choose Formula is =ISERROR() and then choose same colour
font as the background colour

No comments: