Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |