View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default =IF(ISERROR) doesn't work

I have three conditional formats on a cell:

1. Cell value is less than 0 (it works)
2. Formula is =(B10="") (it works)
3. Formula is =IF(ISERROR) (doesn't work)

I've tried various combinations to get number 3 to work -
can someone suggest a fix?

Thanks,
Phil