Highlight duplicate cell and filter by color

[aleksandra_budnik]

First, we need to define if a duplicate is

• the same value is a column
  
  
• the same value in a row
• the same value in a table
• the same row data
• the same column data

All those cases require a different condition to be used.