View Single Post
  #1   Report Post  
RjS, CISSP
 
Posts: n/a
Default 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.