Changling Color Or Cells For Profit & Loss

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Apr 5, 2009

• #2

You can just go to format - cells - number.
And select red font for negative numbers.

 

Upvote 0

jim may

Well-known Member

Joined

Jul 4, 2004

Messages

7,486

• Apr 5, 2009

• #3

check out Conditional Formatting

 

Upvote 0

crimson_b1ade

Well-known Member

Joined

Sep 27, 2008

Messages

1,557

• Apr 5, 2009

• #4

That horse (of the conditional formatting kind) has been beaten to death...resurrected then beaten to death again. Rinse and repeat. Always try doing a search on the board first.

Drakey said:

Hi everyone,

I'm making a profit and loss statement and I would appreciate it if someone could tell me how to change the color of a cell to red for a loss, and make it stay green if a profit was made.

Any help would be greatly appreciated.

Tyson.

Click to expand...

 

Upvote 0

D

Drakey

New Member

Joined

Mar 25, 2008

Messages

8

• Apr 6, 2009

• #5

Thanks Jim.

 

Upvote 0