A

#### Ash

"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