Highlight duplicate values with conditions

[messa57fr]

Hi everyone,

Thanks for reading my post, I'm looking to highlight duplicate values within 24 hours from the previous duplicate value.

I'm using this but this is not what I want, I would like to replace NOW() with the timestamp of the previous duplicated value (if exist)
=AND(J2>=NOW()-1,COUNTIF(B:B,B2)>1)

My time stamp looks like that: 1/12/2022 08:05:47

Not sure if it's clear enough, but let me know. Thanks!
Sam

 

[messa57fr]

Yeah it works! Amazing! Thank you so much!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.