 |
 | 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 / March 2008Excel 2007 Conditional Formatting problem
I have a conditional format that works fine on the previous version of Excel, but not so well on 2007. It is a formula condition: =AND($D$13 = "N",LEFT($D$6,2) = "AP")=TRUE D13 is the cell with the conditional format in it and D6 is a drop down of items, some of which start with "AP" and some of which start with "GL". (Basically, I'm having D13 turn red when D13 has a value of "N" and D6 starts with "AP".) It works just fine if you are changing the value of D13. It doesn't work at all if you are changing the value of D6-- UNTIL you hit F2 on D13 (or otherwise enter the edit-cell mode). Anyone have any ideas what the problem might be? Thanks. I changed your formula to =AND($D$13 = "N",LEFT($D$6,2) = "AP") This returns TRUE or FALSE. There is no need to test for equality to TRUE. The formula works fine. No need to press F2. The formatting takes immediate effect when D6 is AP12 and D13 is an N. Do you have your calculation mode set to manual? Tyro >I have a conditional format that works fine on the previous version of > Excel, but not so well on 2007. [quoted text clipped - 14 lines] > > Thanks. I made the change you suggested, but it's still exhibiting the same behavior. Calculation is set to Automatic. Now here's something weird I noticed just now: If I enter a value into any other cell in Row 13, the formatting will activate (if D13 and D6 are the right values), but it does not if a value is entered into a cell on any other row. Maybe my copy of Excel is just buggy. Thanks for taking the time to help. > I changed your formula to =AND($D$13 = "N",LEFT($D$6,2) = "AP") This > returns TRUE or FALSE. There is no need to test for equality to TRUE. [quoted text clipped - 24 lines] > > - Show quoted text - If you like you could upload your workbook to savefile.com and I could take a look at it. Tyro I made the change you suggested, but it's still exhibiting the same behavior. Calculation is set to Automatic. Now here's something weird I noticed just now: If I enter a value into any other cell in Row 13, the formatting will activate (if D13 and D6 are the right values), but it does not if a value is entered into a cell on any other row. Maybe my copy of Excel is just buggy. Thanks for taking the time to help. On Mar 7, 11:27 am, "Tyro" <T...@hotmail.com> wrote: > I changed your formula to =AND($D$13 = "N",LEFT($D$6,2) = "AP") This > returns TRUE or FALSE. There is no need to test for equality to TRUE. [quoted text clipped - 29 lines] > > - Show quoted text - Ok. I will send the link to your email. Thanks. > If you like you could upload your workbook to savefile.com and I could take > a look at it. [quoted text clipped - 50 lines] > > - Show quoted text - Best to post the link here. Ok. I will send the link to your email. Thanks. On Mar 7, 1:19 pm, "Tyro" <T...@hotmail.com> wrote: > If you like you could upload your workbook to savefile.com and I could > take [quoted text clipped - 53 lines] > > - Show quoted text - Here is the link. http://www.savefile.com/files/1425602 Thanks again. > Best to post the link here. > [quoted text clipped - 61 lines] > > - Show quoted text - I tested your conditional formatting in your workbook. I encounter the same problem. I tested it in a new workbook and it works fine. I tried to look at the VBA code to see if there is something there but cannot. Password required. Tyro Here is the link. http://www.savefile.com/files/1425602 Thanks again. On Mar 7, 2:37 pm, "Tyro" <T...@hotmail.com> wrote: > Best to post the link here. > [quoted text clipped - 68 lines] > > - Show quoted text - The macro is proprietary, so I can't give out the password, but you can open the file with macros disabled. There's nothing in the macro that should affect formatting. In fact, just as a double-check, I removed the module and everything else in the project entirely and still encountered the same problem. This file was initially created in Excel 2003. I know they revamped conditional formatting for 2007. I wonder if that could be related. I'm not sure how, though. It doesn't make a lot of sense. After some experimenting, though, I see that I don't have the problem in version2007-created documents. Further, when run in Excel 2003, I do not have the problem. > I tested your conditional formatting in your workbook. I encounter the same > problem. I tested it in a new workbook and it works fine. I tried to look at [quoted text clipped - 85 lines] > > - Show quoted text - |
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.