| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
Probably quite an easy one but i'm trying to get the cell to be green if it
is above 0, red if it is below and no colour if it is 0, however, the values in the cells are part of a formula ie If(A1="", "", B1-C2) so if A1 is blank, the current cell will be blank. But for some reason the condional format see's the formula as being greater than 0 and whatever I do, it colours the cell green, any suggestions?? -- Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
| Conditional format numbers | Excel Worksheet Functions | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Conditional Format Question | Excel Worksheet Functions | |||
Threaded Mode
