You probably have text in the data.

You can either reformat, or change your CF to a formula, like =--A2<0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RjS, CISSP" wrote in message
...
Hi Folks
I have a financial spreadsheet that was created from a webpage by
importing
the data. Data seems to have imported OK and cells are correctly formatted
at
"Currency". But when I apply a CF of Cell value is less than 0, and the
cell
contains a minus number, it absolutely ignores it. In fact, if I apply a
CF
of Cell Value is Greater Than 0, and the cell contains a MINUS number, the
CF
returns true and applies the CF formatting.

Any Suggestions?

Thanks in advance.