net

B

bn_dubai

Dear All ,

Can you please help in this

i'm creating excel sheet for finance purpose
and i need the number appear with color
for example if the net = +ve (i need it to appear with green color )
and if it is = - neg (i need to appear with red color )

any one can help me with the color

thansk for your cooperations
 
P

Pete

You can use Conditional Format to get this effect - select the cell in
question, then select Format | Conditional Format. Select the condition
(Cell Contents > 0), then the Format effect you require (Colour set to
Green), click OK then AND for another condition, Cell Contents < 0,
Format Colour set to Red. Any zero value would be shown at the default
colour setting.

Pete
 
D

Danny@Kendal

bn_dubai said:
Dear All ,

Can you please help in this

i'm creating excel sheet for finance purpose
and i need the number appear with color
for example if the net = +ve (i need it to appear with green color )
and if it is = - neg (i need to appear with red color )
Click to expand...

Try this as a custom cell format.
[Color10]£* #,###;[Red]-£* #,###

Change the Pound sign to whichever currency you want to represent.
If you want the currency symbol to be up against the numbers rather than
spaced out to the left then just remove the "* " (asterisk space)

You could use "Green" instead of "Color10" but that's very bright and hard
to read against the usual white Excel background.

See here http://www.geocities.com/davemcritchie/excel/colors.htm for a list
of colour numbers. Don't forget to use the American spelling of "Color" not
the English "Colour".
 
Top