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?