Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting
Trying to compare to numbers, some are negative. The cells contain formulas
so I am using formulas verses cell values for comparision. The problem I am having is when the numbers are negative. We are comparing a loss of -4.39 (cell a6) which is better and the one we want the format applied to, than -4.72 (cell a8) but since these numbers are only sometimes negative the forumla is =a6a8 for a formatting result of yellow background. Is there a formula for when negative numbers will sometimes be involved? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |