 |
 | 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 / February 2007Advanced Conditional Formatting and Changing Cell Colours
I have three basic (for programmers) conditional formatting problems to solve in Excel for which I require some help. These are the last 3 conditions I need to complete for the worksheet so any help will be really appreciated. They are as follows: 1. If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell Z2 2. If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I need to change the colour of the cell containing "Z" (V2, W2 or X2). If changing the colour of only the single cell containing "Z" cannot be done, I guess changing the colour of the whole row would be okay. 3. If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the colour of the row Thanks to the google group community in advance! Might be an idea if you read the replies to your last two postings on the same subject. Gord Dibben MS Excel MVP >I have three basic (for programmers) conditional formatting problems >to solve in Excel for which I require some help. These are the last 3 [quoted text clipped - 16 lines] > >Thanks to the google group community in advance! > Might be an idea if you read the replies to your last two postings on the same > subject. [quoted text clipped - 23 lines] > > - Show quoted text - Unfortunately the info they contain is not correct. I am posting them again in attempt to get a response that I can use, but you can be rude and nasty about it if you like. I guess no one can stop you If the responses to your other posts did not help, stick(reply)to the threads you found them in and explain what did or did not work rather than just posting again in another news group. That's how things are done in these groups in order to maximize the assistance you get. If you consider this to be a rude and nasty reply then I do not apologize. Gord >> Might be an idea if you read the replies to your last two postings on the same >> subject. [quoted text clipped - 27 lines] >again in attempt to get a response that I can use, but you can be rude >and nasty about it if you like. I guess no one can stop you > If the responses to your other posts did not help, stick(reply)to the threads > you found them in and explain what did or did not work rather than just posting [quoted text clipped - 40 lines] > > - Show quoted text - This wasn't a rude and nasty response at all. Your first one was, and don't worry I certainly wasn't expecting an apology from your decent self Just as flies are attracted to sugar, and not vinegar, helpful suggestions are attracted by congenial requests and responses, not ones that are discourteous and/or impertinent. Such threads are just ignored and left unanswered.  SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- On Feb 9, 2:17 pm, Gord Dibben <gorddibbATshawDOTca> wrote: > If the responses to your other posts did not help, stick(reply)to the > threads [quoted text clipped - 46 lines] > > - Show quoted text - This wasn't a rude and nasty response at all. Your first one was, and don't worry I certainly wasn't expecting an apology from your decent self |
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.