 |
 | 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 / Programming / May 2008Sticky interior colors
From within a macro I'm trying to set the interior color of cells based on their value, but I notice that cells which are already colored won't change. Even manually they won't change. If I first clear format in the cells then it works. Does this sound familiar to anyone? I don't want to first clear formats because other formats get lost. Any suggestions? David Portwood If you can't change the existing colors you may have Conditional Formatting applied to those cells. Tim > From within a macro I'm trying to set the interior color of cells based on > their value, but I notice that cells which are already colored won't [quoted text clipped - 5 lines] > > David Portwood Yes, as a matter of fact I think I do. Thanks very much, Tim. > If you can't change the existing colors you may have Conditional > Formatting applied to those cells. [quoted text clipped - 10 lines] >> >> David Portwood |
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.