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.