| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
