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