Hi,

Select A1:A1 then

Format|Conditional format
Formula is
=SUMPRODUCT(--($A1<"")*($A1:$Q1=$A1))=17

Pick a colour.
OK

Use the format painter to paint this into other rows as required.

Mike

"Paula" wrote:

Hi, I have read the pages of excel duplicates and I can work out how to find
duplicate rows, however I only want to identify an entire row as a duplicate
if every
single cell from row a-q exactly matches, any ideas how I would do this? I
don't have 2007 excel so don't have the data delete duplicates option.

Many thanks for your advice.
Paula