| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting problem
My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?
Here's my 1st for (GREEN) =IF(AND(M60,N6="Inc"),TRUE, FALSE)) Here's my 2nd for (YELLOW) =IF(AND(M6<0,N6="Inc"),TRUE,FALSE)) This formula still returns a YELLOW format? Here's my 3rd for (RED) =IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE)) James A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
| Conditional formatting problem | Excel Discussion (Misc queries) | |||
| Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
| Conditional Formatting Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
