Conditional Formatting Pbm
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.
|