Excel 2007 Conditional Formatting problem

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

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 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.
 
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.
 
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.
 
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.
 
Back
Top