|
|
Location: Wigan
Joined: Feb 2007
Posts: 1,676
|
20-07-2007, 06:39 PM
microsoft excel
my OH is settin up his own business and i said i would do his books. i have set up a spreadsheet using excel and want to show profit in black and loss in red. I know i need to use an IF statement but im not sure how. any ideas??ATD xxx
|
|
Location: East Sussex, UK
Joined: Sep 2006
Posts: 4,384
|
20-07-2007, 07:00 PM
on the Format option select conditional formatting
use the values between 1 and 99999999 to be in black - should be self explanatory but if not shout!
and use less than 0 to be in red!
ok?
|
|
lets just hope there is more black than red lol |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|