highlighting duplicate cells

A happy NEW YEAR to everyone.

My problem!
I currently have a database set up however in column F I would like to input a function which would automatically highlight any duplicate data I enter. Normally I would use conditional formatting for this however as i have already used the conditional format 3 times I cannot use this further.

I have never used a macro or vba coding for that matter.

If you know of a function I would be grateful.

Hi,

Are you looking for duplicates in a single column - e.g. F?
If so you could use use a COUNTIF() function

i.e.

Please Login or Register  to view this content.

Copy this down and then filter this column for values >1 - or conditionally format this helper column.

HTH

Originally Posted by langdon37

Many thanks however i do not follow.

There is just one column I need to filter and what I need to find are any series of numbers that match like below:-

Hi,

Have you subtly changed your original question? Above you mention 'any series' of numbers, implying to me any run of numbers. Your OP simply said you wanted duplicates for any number you entered.

If your original Q still stands, please adjust the original formula I gave you, (I had mistakenly thought you were looking for the the second and subsequent duplicates) and use the following in a helper column.

Please Login or Register  to view this content.

change the F4 ref as appropriate. Note that this returns 3,3,1,3 in the column in which you enter it.

Then just use the Formula Is Conditional format in column F to test for values >1 in the helper column.

HTH