CF Highlight numbers from previous row.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,446
Office Version
  1. 2007
Platform
  1. Windows
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.
 
Last edited:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Select F8:J9 & use this formula
=F8=F9
 
Upvote 0
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
 
Upvote 0
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.
 
Last edited:
Upvote 0
Wow, so many responses, Thanks to all of you, I really appreciate your light speed responses.
Serge.
 
Upvote 0
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.
 
Upvote 0
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.
 
Last edited:
Upvote 0
No I didn't, I just tried it now it works fine, I should had tried it before I posted.Thank you Marcelo.
 
Upvote 0
Thank you Eric, I appreciate your help.
Serge.
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top