|
|
ste01
new user
Reg'd: Mon
Posts: 2
|
|
hi there all, i have a quick question, how do you turn the colour of the text to a different colour??
for example if you outcome is negitive the number will automaticly turn red.
any help would be great.
ste
|
|
greysts
regular
Reg'd: Thu
Posts: 17961
Loc: Colchester
|
|
Highlight the cell or group of cells in question then choose Format, Cells, Number, Number then choose Negative Numbers shown in red. At least that's how you do it in Excel 2003.
--------------------
Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.
|
ste01
new user
Reg'd: Mon
Posts: 2
|
|
thankyou very much, i did know how to do that once, forgot though, its been a long time.
cheers .
|
|
|