View Single Post
  #1   Report Post  
Mcasteel
 
Posts: n/a
Default 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