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?? |
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 |