 |
 | 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 / December 2006Colour cells
Is there a formula which will colour cells.(Not conditional format) want to say that if cell A1 = B1 then cell f12 will turn green. Possible -- colinfraser@prosealuk.co Posted from - http://www.officehelp.i If you don't want to use Conditional Formatting because for example you are already using it and have exceeded the 3 formats limit, then you will have to go with a VBA solution. > Is there a formula which will colour cells.(Not conditional format) I > want to say that if cell A1 = B1 then cell f12 will turn green. [quoted text clipped - 8 lines] > > Posted from - http://www.officehelp.in If, as Richard guessed, you are looking for more than three conditions, you may want to look at Bob Phillips' and Frank Kabels' solution. http://www.xldynamic.com/source/xld.CFPlus.Download.html HTH Martin
|
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.