 |
 | 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 / Worksheet Functions / August 2006multiple condition lookup and match cell format
Sheet 1: A 35 cell column, each with user intials "XXX", each cell is formatted with font and pattern choices. Sheet 2: Cells A1:M15. If the contents of a cell matches one of the cells in Sheet 1, match the contents and the format of that cell. Can't use conditions, because there are only three. I'm hoping I just don't get arrays yet. This doesn't make much sense - perhaps you can describe your problem more fully. I dont understand this bit: " ... match the contents ... " because in the same sentence you say: " ... If the contents of a cell matches one of the cells ... " Also, a formula can only return a result, not a format, so if this is crucial to you then you would need to use VBA. Pete > in Sheet 1 > Sheet 1: A 35 cell column, each with user intials "XXX", each cell is [quoted text clipped - 3 lines] > Can't use conditions, because there are only three. I'm hoping I just don't > get arrays yet. i want the value of the cell and the cell format to be captured. If A1 is XXX and the cell font is white and the pattern is black, then i want that result. But if A29 is AAA and cell font is yellow and the pattern is red, then I want that result. There are 36 or more cells, each with different font and different pattern. I can get it with conditional formatting but that only works for three conditions. I'm sorry, I have extemely limited VBA knowledge. > This doesn't make much sense - perhaps you can describe your problem > more fully. [quoted text clipped - 19 lines] > > Can't use conditions, because there are only three. I'm hoping I just don't > > get arrays yet. I was able to get the VBA code from Ozgrid.com and I'm happy to say it did the job. > Sheet 1: A 35 cell column, each with user intials "XXX", each cell is > formatted with font and pattern choices. > Sheet 2: Cells A1:M15. If the contents of a cell matches one of the cells > in Sheet 1, match the contents and the format of that cell. > Can't use conditions, because there are only three. I'm hoping I just don't > get arrays yet. |
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.