Find Duplicate - Highlight Cells

[da80th]

hi All,

I am trying to find the excel formula that highlight cells that contain duplicate number immediate following cell, for example:

1. 28
2. 26
3. 16
4. 29
5. 29
6. 16
7. 50
8. 28
9. 46
10.32

So row 4 and 5 should highlighted because it contained two same number 29. BUT rows 3 and 6 will not highlight because it does not immediate in the following row.

Thanks

[GazB]

On conditional formatting, you should be able to use:

Please Login or Register  to view this content.

[oeldere]

See conditional format

Excel 2007 => start => conditional format

[da80th]

On conditional formatting, you should be able to use:

Please Login or Register  to view this content.

that formula doesn't work the way I wanted. I want only cells that contain same number, but must also found from immediate cells, e.g. #29 from found in row 4 and row 5.

[oeldere]

Untested, try this one.

Please Login or Register  to view this content.

[FDibbins]

CF has an option to highlight duplicate cells, try using that

[da80th]

Untested, try this one.

Please Login or Register  to view this content.

sorry, but that formula doesn't highlighted the cells that contain same number, can you please try again

also, the cells that contain same number MUST follow immediate below each other.

thanks

[oeldere]

@FDibbins

OP writes

Please Login or Register  to view this content.

so this wil not be the solution

Your options will highlight all duplicated values.

[oeldere]

Please Login or Register  to view this content.

As i wrote, i didn't tested it.

It's your file so you can test it.

I tested it (now) in a dummy file, and it works.

So my advice is try again.

[da80th]

I attached my excel file, can you try again.

thanks

[oeldere]

See the attached file for the CF.

[da80th]

can you test on my attached excel file, sorry for bothering you,

thanks in advance

[oeldere]

Thanks for the reply.

Glad i could help.

If the question is solved, will you mark it as solved?

[da80th]

Thanks for the reply.

Glad i could help.

If the question is solved, will you mark it as solved?

I am still having problem, I can't seem to applied the formula to the entire sheet. can you try again

thanks

[oeldere]

I don't see a file in your last post.

Did you copy - format past (with the brush).

That should do the job for you.

[da80th]

can you test on my attached excel file, sorry for bothering you,

thanks in advance

thanks again

[oeldere]

As I said, you can do that using the brush.

See the attached file.

[da80th]

Thank you very much

[oeldere]

Thanks for the reply.

Glad i could help.

If the question is solved, will you mark it as solved?