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.