=IF(ISERROR) doesn't work

[Phil Hageman]

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

 

[Chip Pearson]

Phil,

Try

=ISERROR(B10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)