Unique Entries/Cell Back Color

[Allison]

I have two columns with Grant Numbers in each column
coming from two different databases downloaded to an excel
spreadsheet. I will need to first Match the Grant numbers
and highlight the whole row if something is unique meaning
there are duplicates,triplicates, one exist in one column
but not in the other. I need your help!

 

[Allison]

Thanks but for some reason this is not working. Should I
put my formula in column C? I have two columns with data
in cells A1-A6266 and data in column B1-B5016. I can see
the formula it's not working in column C with the results.
is there a command that I'm missing to execute?

 

[Bob Phillips]

Allison,

No this is conditional formatting.

Select rows 1-6266
Goto menu Format>Conditional Formatting
Change Condition1 to FormulaIs
Enter the formula
=AND(COUNTIF($A$1:$A$6266,A1)=1,COUNTIF($B$1:$B$5016,B1)=1)
Select the Format button
Select the Pattern tab
Choose your highlight colour
Exit and it should all be okay