Great works fine: Thanks Gary`s Student!
I`m using just -999 which is small enough.
But how do I use conditional formatting to `white-out` the text for those
cells
I`ve tried <900 and =-999 as conditions, But they don`t seem to work?
Any ideas about this?
Thanks.


"Gary''s Student" wrote:

=IF(ISERROR((GD17-FE17)/2),-999999,(GD17-FE17)/2)
or any other very large negative value
--
Gary''s Student - gsnu200901


"Romileyrunner1" wrote:

Hi, have collumns with numerical results but also error cells which appear
blank due to the formula:
=IF(ISERROR((GD17-FE17)/2),"",(GD17-FE17)/2)
being applied.

When I sort on `desending order` I want the highest numerical results at top
of collumns and the error (BLANK) cells at the bottom.

Any suggestions Guys?
Thanks.