 |
 | 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 / New Users / October 2006Changing background and font colors in formulas
How would I go about changing colors within a formula. What I would like to do is as follows. As example, formula would be in cell H37. If G37 > Now() and I37 is < 100%, then "RED" else "GREEN" Where text indicated is RED, then I want the font black and the background color to be red Where text indicated is GREEN, then I want the font to be white and the background color to be green. Can this be accomplished within the formula? Not possible in a formula. Only in text  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > How would I go about changing colors within a formula. What I would > like to do is as follows. As example, formula would be in cell H37. [quoted text clipped - 7 lines] > > Can this be accomplished within the formula? Thank you Don, but it is sort of possible. I just figured it out. It's possible thru the use of Conditional Formatting. Goto the cell you want to format, choose Format and Conditional Formatting from tool bar...and the colors will be changed based on whatever criteria is set. It's a bit different than having it withing the formula, but the goal is accomplished. > Not possible in a formula. Only in text > [quoted text clipped - 13 lines] > > > > Can this be accomplished within the formula? Your question was "within" the formula SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Thank you Don, but it is sort of possible. I just figured it out. > It's possible thru the use of Conditional Formatting. Goto the cell [quoted text clipped - 20 lines] >> > >> > Can this be accomplished within the formula? Yes, but Conditional Formatting is use of formulas. <egregious grin> The only coloring shown "within" a formula is nesting, but from the question it would be obvious that it was "By" a formula. Cell formulas are not the only use of formulas on the worksheet, Conditional Formatting is based on the same kind of formulas as used in cell formulas. The formulas in Conditional Formatting resolve to True or False. with errors being resolved as False. More information on Conditional Formatting in http://www.mvps.org/dmcritchie/excel/condfmt.htm HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Your question was "within" the formula |
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
|
©2008 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.