Conditional Formatting Multiple Rows

[LG1987]

Hi,

I am looking to check that two columns in excel match. I can use conditional formatting to check each row at a time but when I drag it down to cover multiple rows it is searching all the cells for duplicates not just each individual row. I can format each row individually but this may take a very long time. Is there another way of doing this? Any help would be greatly appreciated.

[Fotis1991]

Hi

What formula are you using?

[LG1987]

I am using
Duplicate values and appyling it this way=$O$196:$Q$196

[mubashir aziz]

i think some examples or sample file can describe your problem clearly

[Fotis1991]

Di you try?

=$O196:$Q196

No absolute reference, and copy.

[LG1987]

Yes. This is not working for me. I am wanting to make sure that 2 cells in same row match. With this it is showing me if any other cell match any other cell in the range.

[Fotis1991]

Take a look to the example.

Is this, works for you?

[LG1987]

that works perfectly thank you

[Cutter]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save