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]
test.ods
Description: application/vnd.oasis.opendocument.spreadsheet--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
