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:
Post a Comment