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