| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula query
Hello,
I need a formula which will do the following; 1) calculate the difference between two cells (say A1 and A2) 2) display the result of that difference in colour, i.e. green if the result is a positive figure, and red if it is a negative figure. Help with this is grately appreciated - Thank You |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula query
No need for assistance - sorted it myself. Thanks
"IoHeFy" wrote: Hello, I need a formula which will do the following; 1) calculate the difference between two cells (say A1 and A2) 2) display the result of that difference in colour, i.e. green if the result is a positive figure, and red if it is a negative figure. Help with this is grately appreciated - Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| query formula | Excel Discussion (Misc queries) | |||
| Formula query | Excel Worksheet Functions | |||
| Formula Query | Excel Discussion (Misc queries) | |||
| formula query | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
