I don't see how that helps in highlighting NA's--it does all errors. --Tom
Anthony Chilco wrote:
What about using the iserror function? tc
Tom Wainwright wrote:
Pedro--
Thanks for the suggestion, but that doesn't solve the problem of being able to distinguish NA's from zero values. Recoding zeros as something else would rather mess up any statistics I'm running.
==Tom
Pedro Santos wrote:
I hope this helps. I think that your problem was using the values true, false and NA.
You can solve this with some cheating. True is 1 and False is 0, by logics. Place True equal to 2, by TRUE()+1=2, same applies to False, it will be FALSE()+1=1
Now you will not have the problem with the zero value.
Using conditional formatting I can check what is NA, True and False. I send a spreadsheet with an example.
Pedro Santos
Thomas C. Wainwright wrote:
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]
