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