Why does conditional formatting remain static?
 

I'm about to go nuts! I followed the directions for locating duplicate
numbers by conditional formatting. I put the formula in like it says, but
when I go to copy it to the rest of my column, it stays the same all the way
down.

COUNTIF(A2:A1209,A2)1
Shouldn't it change to COUNTIF(A3:A1210,A3)1 on the next row?
If not, what am I doing wrong??

Why does conditional formatting remain static?
 

It certainly should. Are you sure you didn't actually enter =
COUNTIF($A$2:$A$1209,$A$2)1?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carrie" wrote in message
...
I'm about to go nuts! I followed the directions for locating duplicate
numbers by conditional formatting. I put the formula in like it says, but
when I go to copy it to the rest of my column, it stays the same all the
way
down.

COUNTIF(A2:A1209,A2)1
Shouldn't it change to COUNTIF(A3:A1210,A3)1 on the next row?
If not, what am I doing wrong??

Why does conditional formatting remain static?
 

Well, at first I thought I might have done that, but I rechecked it. No $ in
my formula.

"Bob Phillips" wrote:

It certainly should. Are you sure you didn't actually enter =
COUNTIF($A$2:$A$1209,$A$2)1?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carrie" wrote in message
...
I'm about to go nuts! I followed the directions for locating duplicate
numbers by conditional formatting. I put the formula in like it says, but
when I go to copy it to the rest of my column, it stays the same all the
way
down.

COUNTIF(A2:A1209,A2)1
Shouldn't it change to COUNTIF(A3:A1210,A3)1 on the next row?
If not, what am I doing wrong??

Why does conditional formatting remain static?
 

toolsoptionscalculation set to automatic


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Carrie" wrote in message
...
Well, at first I thought I might have done that, but I rechecked it. No $
in
my formula.

"Bob Phillips" wrote:

It certainly should. Are you sure you didn't actually enter =
COUNTIF($A$2:$A$1209,$A$2)1?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carrie" wrote in message
...
I'm about to go nuts! I followed the directions for locating duplicate
numbers by conditional formatting. I put the formula in like it says,
but
when I go to copy it to the rest of my column, it stays the same all
the
way
down.

COUNTIF(A2:A1209,A2)1
Shouldn't it change to COUNTIF(A3:A1210,A3)1 on the next row?
If not, what am I doing wrong??