| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making gains or losses appear red or black in formula
i'm keeping track of my stock gains and losses...How can I make the formula
determine what color either will be???? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making gains or losses appear red or black in formula
Have you tried Number Formats?
<Format<Cells<Number tab or Custom Number Formats? (check Excel help) or Conditional Formatting?<Format<Conditional Formatting http://www.contextures.com/xlCondFormat01.html *********** Regards, Ron XL2002, WinXP-Pro "Blane" wrote: i'm keeping track of my stock gains and losses...How can I make the formula determine what color either will be???? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Making this formula work | Excel Worksheet Functions | |||
| Making a formula continuous | Excel Discussion (Misc queries) | |||
| Cease Excel's "formula making" | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Hybrid Mode
