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

Phil,

Try

=ISERROR(B10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Phil Hageman" wrote in message
...
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