conditional format formula not always working

[Todd]

Hi, I am using this formula for a conditional format. It
looks for numbers that are repeated in a column and
highlights all repeated occurances. The idea is to let me
know if I already entered an invoice so I won't do it
again.

It works fine but it isn't consistent. I have a few
columns where it will highlight the first occurance only.
I am trying to figure out why. Any ideas?


=IF(COUNTIF(Range3, B482)>1,TRUE,FALSE)

TIA

Todd

 

[Todd]

I am changing my question! I rechecked the range and the
cells in the range were different than I had created
(intended to anyway). They origonally were set C10:c800
and was c222:c1497. What did I do to make the range
change like that? I had to reset it several times. Why
is it different than what I name it. ???

Todd

 

[Peo Sjoblom]

When you name the range use absolute references, i.e.

=Sheet1!$C$10:$C$800

(replace Sheet1 with your sheet name)