Friends--
I am trying to use conditional formatting to highlight missing values (#N/A) in a numeric spreadsheet. The logical way of doing this would be to set a condition of cell value equal to na(). Unfortunately, while this highlights all the cells with values of #N/A, it also highlights all the cells with a value of zero (or FALSE) as well. (This behavior was submitted as a bug, issue #46336.) Does anyone know of a workaround, i.e. how to highlight ONLY missing values using conditional formatting?
Thanks in advance for your help.
-- Tom
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
