Seemore,

Glad I could help,

Conan



"Seemore" wrote in message
...
On Feb 5, 6:25 pm, "Conan Kelly"
wrote:
Seemore,

I found that if I had merged
cells in the worksheet, it didn't work.

I think that you will find on this NG, most people will suggest that you
do
not use merged cells. They tend to be difficult to work with when you are
using code or formulas. If it is at all possible, remove the merging.

Is there a better solution that works more often?

Not until we figure out why this solution isn't working correctly. Can you
inspect the cells where you believe they should match and try to determine
why it isn't? Also, make sure to check if your Auto Calculation is turned
on: Tools menu Options... Calculation tab Calculation section make
sure Automatic option button is selected, then click OK.

Other than that, I can't think of why this wouldn't be working. With out
being able to look at the file myself, I don't think I can be much more
help
to you.

Sorry,

Conan



Something is very bizzare. I really couldn't get anything but the
conditional formatting to work properly. In fact, the conditional
programming does not work every time. I found that if I had merged
cells in the worksheet, it didn't work. It may work on one worksheet
and not another. I can't figure it out. Is there a better solution
that works more often?- Hide quoted text -

- Show quoted text -

Actually, I think I'm cool now. I had unmerged the file but option 2
was working only sometimes. Option 1 on the other hand, I was doing
it wrong. I didn't quite understand your instructions but after I
reread it, it works perfectly. Option 1 is perfect and that is the
one I'll use. Again, I appreciate all your help.