I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column. I have for instance a table:
x a b a
a x x b
c b c x
And I need to highlight only cells with "x"-value which is present in every columns. But simple duplicates conditional formatting (like this one ) will highlights all of the cells, because every value has a duplicate in the entire table.
Any suggestions?
Edit not from OP to add clarification/image from comments elsewhere
Products are the columns themselves and in rows there are attributes of the product. By duplicate I mean a value (any row) in every column. Most of the attributes of the products are the same but located in different rows. I cannot sort them and arrange for example in the alphabetical order because it will turn the whole data structure to a mess. Here is an example of what I want to get: https://docs.google.com/spreadsheet/ccc?key=0Ah55-OVCGmw_dDJpMG9qMHhsLTBwbWlxMVQzdHBGYVE#gid=0. As you can see, all the values that are common for all columns are highlighted: