Hi Sean, Thank you for responding.

Okay I've used the formulas you provided.

1) I still have the copy paste error, in that the cf formula is not
"filling down" For example, I copied row 2 and paste specialed, formats only
on rows 3 - 708. Row 708 has the instance where all 3 columns are the same.
I looked at the formula in row 708 and it shows =AND(A3=C3,B3=C3)
2) Since I was still getting the error, I decided to try the formula on row
708 by entering the formula in directly. It still didn't work.

Any ideas where I'm going wrong?
I truly appreciate your help!


"Sean Timmons" wrote:

let's say the columns are A B and C

in c2 format wil be

Formula is:

=AND(A2=C2,B2=C2)

2nd calc will be

=B2=C2

If the first formula works, the conditional format will never attempt the
2nd formula.

Leave the $'s out of it since copying the formatting down the column would
need the row numbers to change.

"Ash" wrote:

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