Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet on which I calculate my profit and loss. The final
column on this spreadsheet gives the bottom line: either I earned a profit (positive number) or lost (negative). I would like to color (shade, etc.) the cells based on whether they display a positive or a negative figure. I would like black to represent the positive and red the negative. Is there a way to do this automatically? Thank you!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
format of profit & loss a/c | Charts and Charting in Excel | |||
Profit and Loss Formula | Excel Worksheet Functions | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Calculating Profit and Loss in one column | Excel Worksheet Functions |