April 11th, 2005
Here is another application of conditional formatting. In a prior tip, we reviewed the ISERR function and how it could be used to hide error conditions in any cell in the Calc document.
We can achieve the same effect with conditional formatting as follows.
Original spreadsheet with this pesky error messages.
As before, we need to create a custom cell format prior to opening the conditional formatting dialog. We set the font color to be the same as the backgorund color and we label this style as blank
Now select the cells whose errors we wish to mask and open theConditional Formatting dialog (below) We still use the ISERR function - this time embedded in the condition applied to the selected cells.
The final result. Whichever method you apply to mask the error message is your decision. The advantage of the conditional formatting approach is that the original cell formulas are not complicated with theISERR calls and it is easier to turn the conditional formatting on and off.
Posted in Using OpenOffice Calc | No Comments »
