Home |
Search |
Today's Posts |
#1
|
|||
|
|||
locate duplicates by sing conditional formatting--doesn't work for
Anybody have an idea why I get an error message "Cannot use conditional
formatting for arrays...constants..." when I try to set up the conditional formatting in the first cell in the row I'll be searching for duplicate entries? I am following step by step the MS Assistance article's instructions for finding duplicates using the COUNTIF function. Perhaps there's a work-around or another way to find duplicate data within cells in a row (not duplicate records , though). Thanks. |
#2
|
|||
|
|||
Post the formula that gives you the error
-- Regards, Peo Sjoblom (No private emails please) "kewawoman" wrote in message ... Anybody have an idea why I get an error message "Cannot use conditional formatting for arrays...constants..." when I try to set up the conditional formatting in the first cell in the row I'll be searching for duplicate entries? I am following step by step the MS Assistance article's instructions for finding duplicates using the COUNTIF function. Perhaps there's a work-around or another way to find duplicate data within cells in a row (not duplicate records , though). Thanks. |
#3
|
|||
|
|||
I want to search for duplicate names of bird species in Row G. I could sort
and manually pick out adjacent duplicates, but I'd rather learn how to use shortcuts, such as conditional formatting being applied when a second occurence of the same cell value is detected. For example, the entry in Cell G301 might be Yellow-bellied Sapsucker, and likewise the entry in Cell G302 (or G629 if I didn't sort on this row) might also be Yellow-bellied Spasucker. According to the Microsoft Assistance artilcle, Step One is to write a forula that would apply conditional formatting (e.g., fill color red) to the cell G2 if the contents of G2 matched any other cell in the column. After entering this conditional formatting formula for cell G2, one is supposed to then copy the conditional formatting formula to the rest of the cells in the column. I understant how Step One is supposed to work. I also understand how Step Two will be done, but my problem is I can't even complete Step One, and this is why: after entering the following fomula in the formula box, Excel returns an errow message "Cannot apply conditional formulas to arrays...." The formula I'm trying to use but that does't get recognized is COUNTIF (G:G, G2)1. I've also tried using different columns, and specifying the G column cells specifically as G2:G3705. Any help is appreciated. "Peo Sjoblom" wrote: Post the formula that gives you the error -- Regards, Peo Sjoblom (No private emails please) "kewawoman" wrote in message ... Anybody have an idea why I get an error message "Cannot use conditional formatting for arrays...constants..." when I try to set up the conditional formatting in the first cell in the row I'll be searching for duplicate entries? I am following step by step the MS Assistance article's instructions for finding duplicates using the COUNTIF function. Perhaps there's a work-around or another way to find duplicate data within cells in a row (not duplicate records , though). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |