Change Text Colot to RED *IF cell value is positve?
 

I'm creating a performance monitoring excel sheet for my stock
positions.

I want the color of my PERCENT RETURN value column to be green if the
value is positive and red if it is a negative value. Can I do this in
excel? or do I have to create a vba macro?


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=277997

Hi
use 'Format - Conditional Format' for this. see:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Mcasteel wrote:
I'm creating a performance monitoring excel sheet for my stock
positions.

I want the color of my PERCENT RETURN value column to be green if the
value is positive and red if it is a negative value. Can I do this
in
excel? or do I have to create a vba macro?

Hi,

There is another way of solving this problem - you can tweak the number format

Go To FormatCellsCategoryCustom
In the Type field, type the following

[0][Green];[<0][Red]

Regards,

Ashish Mathur

"Mcasteel" wrote:


I'm creating a performance monitoring excel sheet for my stock
positions.

I want the color of my PERCENT RETURN value column to be green if the
value is positive and red if it is a negative value. Can I do this in
excel? or do I have to create a vba macro?


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=277997