Keeping conditonal formating with the cell

[DJ_DEF_CON_1]

I have created a mapping spreadsheet where users can hi-light and move cells around a map with other information and the spreadsheet would show the updated information with it.

Here we go:
Cell A1 has some conditional formatting 'IF B$1$ <> C$1' then change the color of the cell. The user cannot move the data in C1 but can drag the data out of B1 and move some other data there.

What I'm hoping is that when they move some other data there A1 will now recognize it doesn't match C1 then turn color. When they open the sheet B1 always equals C1.

Even though I make the conditional formatting absolute with the dollar signs, when a user drags the information away, the conditional formatting updates to where the user moved it.

Does anyone know how to keep the conditional formatting there even though the user is dragging around the cells that the conditional formatting is based on?

EXCEL 97.

I hope this is clear.

Thanks in advnace.

 

[shades]

Howdy. It will have to be done with VBA. But I'm not sure about XL 97. I will post what I have tomorrow, unless someone else can provide.
________
Buy No2

 

[unmarkedhelicopter]

=indirect("B1")<>C1

 

[DJ_DEF_CON_1]

Thanks!

Thanks very much. That works like a charm

 

[shades]

I guess I misunderstood what was requested. But that isn't the first time...
________
Yp400 Majesty