On Thursday 31 March 2005 18:22, 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 >
Instead of using conditional formatting, you can add the STYLE function to your existing formula. This function always returns a value of 0, so does not affect the cell value. e.g. Your formula+STYLE(IF(ISNA(CURRENT());"red";"green")) where "red"/"green" are previously created styles. HTH Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
