I have three columns of data for which I need to identify if there any are
"repeats". If the data is the same for all three columns, I need to
highlight the third column cell in one color, but if only the second two
columns are the same, I need to highlight the third column cell a different
color.

Problem 1) I've tried using the formula in conditional formatting - but to
no avail.

The formula I used: =p2=o2=n2 If this is true, I said to format a
color. First when I copy the formula down, it does fill down for each cell.
When I click manage rules, the formula shows as =$p$2=$o$2=$n$2 I tried
copy/paste special, and this worked for from one cell to one cell, but when I
copy/paste special for all rows of data, it again converted the formula to
have dollar signs.

Problem 2) I then went to a row where I knew the formula to be true and
applied to the cf formula to just that cell. I did not get any highlighting
of the cell. I confirmed that there were no dollar signs and that the
numberics matched the correct row number.

Problem 3) Once I solve the problem above, I then need to add a second
format that if all three are not the same, then tell me if two are the same.
I assume that if I check the "Stop if True" box next to the cf formula box,
then the second cf formula will only "kick in" if the first doesn't work. Is
this an accurate assumption?

Any and all help is appreciated!!
Thanks,
Ashley