Solved conditional formatting duplicates

[CJ_London]

It doesn't work when you have two (or more) sets of duplicates: (If I understand the request correctly)

Agreed, but this is what the OP asked for and provided an image to illustrate and the solution is based on that

i want my field to check previous field and if value is same to be red

Not all previous fields

If there were three consecutive fields with the same value, the 2nd and 3rd would be highlighted.

But easy enough to fix in the function - extend the static was value with new values (perhaps separated by a comma) rather than replace it and use instr rather than = for the compare. Not doubt some other coding required to cater for but don't have time to do that right now, paying clients to satisfy

 

[CJ_London]

took a quick look at the changes required - if the OP meant what you think they meant, i..e.

then see attached - had to modify the query filter slightly to cater for nulls