If it's a cell value, look into conditional formatting. Here are a couple
links:

http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"AndyE" wrote in message
...
I am building a chart that has something like =SUM(AK1:AK38) with the
results
on AK39, I need to compare the results of AK39 to the number in AK40. 39
is
going to be my "Actual" and I need that compared to 40 which is my
"Target".
I would also like for the number in 39 to be red if it is less than 40 and
green if it is =. If it can't be done... I can keep going in and changing
the font color, but takes too much time.
Thanks, Andy