 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2006Automatic color for output of a =sum action
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 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 _______ >I am building a chart that has something like =SUM(AK1:AK38) with the >results [quoted text clipped - 6 lines] > the font color, but takes too much time. > Thanks, Andy Thank you, that is what I needed. Wish I could have gotten it to do a line comparison (if Row 10 is Less than row 11 change color to red, for the entire sheet from D-CF, but the work is done untill next time. ~Andy > If it's a cell value, look into conditional formatting. Here are a couple > links: [quoted text clipped - 19 lines] > > the font color, but takes too much time. > > Thanks, Andy You didn't provide quite enough information, but it seems you should be able to write a function to sort the values into color ranges. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Thank you, that is what I needed. Wish I could have gotten it to do a > line [quoted text clipped - 30 lines] >> > the font color, but takes too much time. >> > Thanks, Andy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.