View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.