 |
 | 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 / May 2008conditional formatting
I have a column in which each cell has the option to contain one of six different words. Based on which word is selected, I need 2 to 3 other cells in the same row to change to a yellow highlight. For example, if cell C2 contains the word flat, then I need cells H2 and I2 to become yellow. But, If cell C2 contains the word 2FC, then I2, J2 and L2 need to be yellow.  SignaturePlease let me know if this can be done - I have 6 different variables. SandyB If you are using Excel 2003 or earlier then you are limited to 3 conditional formats in each cell. Pete > I have a column in which each cell has the option to contain one of six > different words. Based on which word is selected, I need 2 to 3 other cells [quoted text clipped - 7 lines] > Please let me know if this can be done - I have 6 different variables. > SandyB I have Excel 2007 - but it has changed and I am not sure how to do it now with the drop down list. Could you tell me the steps to take, please? Thank you! SignatureSandyB > If you are using Excel 2003 or earlier then you are limited to 3 > conditional formats in each cell. [quoted text clipped - 12 lines] > > Please let me know if this can be done - I have 6 different variables. > > SandyB I'm sorry, I don't have XL2007, so I don't know the steps myself - perhaps someone more up-to-date than I will be able to chip in. Pete > I have Excel 2007 - but it has changed and I am not sure how to do it now > with the drop down list. Could you tell me the steps to take, please? Thank [quoted text clipped - 20 lines] > > - Show quoted text - If anyone has the steps I need to follow or any suggestions, I would greatly appreciate hearing frmo you. Thank you! SignatureSandyB > I have a column in which each cell has the option to contain one of six > different words. Based on which word is selected, I need 2 to 3 other cells [quoted text clipped - 4 lines] > > But, If cell C2 contains the word 2FC, then I2, J2 and L2 need to be yellow. |
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.