CF Highlight numbers from previous row.

[serge]

Hi everyone,


Im looking for a CF formula that will highlight number/numbers that repeat in the next row.


I have in cells : F7:J7 3,15,26,32,37.


and in cells : F8:J8 2,15,20,34,37 and would like for the formula to highlight the numbers 15 and 37.


in cells : F9:J9 3,4,20,32,38 and here the 20, there is only 1 repeat from the previous row.


Thank you.
Serge.

 

[Fluff]

Select F8:J9 & use this formula
=F8=F9

 

[Rick Rothstein]

Im looking for a CF formula that will highlight number/numbers that repeat in the next row.

I have in cells : F7:J7 3,15,26,32,37.

and in cells : F8:J8 2,15,20,34,37 and would like for the formula to highlight the numbers 15 and 37.

in cells : F9:J9 3,4,20,32,38 and here the 20, there is only 1 repeat from the previous row.

For the above example values, select cells F7:J9 making sure cell F7 is the active cell, then use this CF formula...

=F7=F6

 

[Eric W]

Select the range F2:J100 (or whatever your bottom row will be). Click Conditional Formatting > New Rule > Use a Formula > and enter:

=COUNTIF($F1:$J1,F2)

click Format... and choose red for your font color.

This will work if the numbers are not necessarily in the same columns.

 

[serge]

Wow, so many responses, Thanks to all of you, I really appreciate your light speed responses.
Serge.

 

[serge]

I'm sorry to come back on this tread, but I missed saying that the the duplicate number (s) could be in any position in the 5 numbers row, meaning :

example : 2,18,23,36,42
5,10,42,53,58

Here the number 42 is in the 5th position but in the 3rd position in the second row !

What formula will work for this example ?

Thank you.
Serge.

 

[Marcelo Branco]

Have you tried Eric's formula in post 4? Adjusting the ranges according your original post
Select F8:J9
In CF try this formula
=COUNTIF($F7:$J7,F8)

M.

 

[serge]

No I didn't, I just tried it now it works fine, I should had tried it before I posted.Thank you Marcelo.

 

[serge]

Thank you Eric, I appreciate your help.
Serge.

 

[Eric W]

Glad we could help.