Conditional formatting for #N/A

deoravi22 · Posted: Sun Jan 04, 2009 11:39 pm Post subject: Conditional formatting for #N/A

I am getting problem with the conditional formatting which is not been applied with cell having #N/A values.

Please help me...
_________________
sed

Villeroy · Posted: Mon Jan 05, 2009 7:59 am Post subject:

Calc has 2 types of valid values, text and number. All dates, times, booleans (True/False) are formatted numbers.
You may consider a blank cell as another type.
Formulas can return errors. Any calcualtion (and comparison) with an error results in an error. Calc has several functions to test the type of data: ISNUMBER, ISTEXT, ISBLANK, ISERROR (any error), ISERR(any but #NA), ISNA
The #NA value is separated from the other errors. Basically it means that a value could not be found although there is nothing wrong with that formula.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org