 |
 | 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 / May 2008Can we change cell color programatically?
Hi all I'm using Excel 2003. Does Excel allow me to change the fill-color of a cell based upon the contents of that cell? For example: If the formula of a cell calculates its value to be less then, say, 100, I'd like to fill-color that cell to Green. Otherwise I'd like to color that cell with no color. Is this possible? Thanks -Mike Take a look at Format|Conditional formatting. You can specify up to 3 rules (and formats) as well as the "normal" format. > Hi all > [quoted text clipped - 11 lines] > > -Mike  SignatureDave Peterson Check out Conditional Formatting on the Format menu. SignatureJim | Hi all | [quoted text clipped - 11 lines] | | -Mike Thanks Dave and Jim for your help. :-) This almost seems to work. It allows me to do what I want if I hard-code a specific value into the conditional formatting setup. However, it does not seem to allow me to specify that the conditional format should be based off of the value within a particular cell, which is what I'd really like for it to do. For example. I've specified cell E5 to contain a value of 145. If I then specify in the conditional format: "Cell Value Is greater than or equal to 145" Excel behaves how I want. However, Excel does not seem to allow me to reference cell E5 (instead of the hard-coded number 145) in the conditional formatting. Is there some what to specify a particular cell reference in the conditional formatting? Thanks again :-) -Mike > Check out Conditional Formatting on the Format menu. > [quoted text clipped - 14 lines] > | > | -Mike Ooops. Just figured it out. Silly me... I just needed to supply =$E$5 for the condition and it all works great. Thanks so much for your help. :-) -Mike > Thanks Dave and Jim for your help. :-) > [quoted text clipped - 35 lines] > > | > > | -Mike Change the drop down on the left of the Conditional Formatting dialog to "Formula is". Now if you wanted the active cell to change format when E5 is 145 the formula you enter is =E5=145. Think of the formula you enter as a true/false. If it evaluates to True you get the format, else you don't. SignatureJim | Thanks Dave and Jim for your help. :-) | [quoted text clipped - 35 lines] | > | | > | -Mike |
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.