Conditional formatting with repeated values

[SzymonKl]

Hi All 

Is there any way to make repeating values in column "order number" be marked with the same colour? In visualization (table)

[SzymonKl]

Hi Ibendlin

No, not necessarily. The example above does not reflect the entire table. Sometimes the record takes one line, and sometimes several. I want the record that is repeated to be of the same colour. 

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[lbendlin]

yes.  What color should be applied?

[SzymonKl]

hi  Ibendlin.  

green please

[lbendlin]

that would mean the entire table would be green?