colour formatting to text

Copper Contributor

In table I want color format rows according to values in particular column E.g.- rows will have same color if value is same in all those rows (there are lots of  values across that column)

5 Replies
Can you perhaps attach an anonymized example file? I find it hard to picture what you need.

Hi @vedantaher,

 

If you want to highlight duplicate cells in just 1 column, you can use "Conditional Formatting > Highligh > Duplicate Values" option.

 

Refer the below link for more details
https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552...

 

Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.

I was looking for a formula and when I read your solutions it was just soooooo simple and it works!!!
thanks for answer but what if i want to highlight whole row on that criteria and there are multiple duplicate value E.g-2 columns of country and cities are there I want rows having same country same color and different color for different rows(countries).
-2 columns of country and cities are there I want rows having same country same color and different color for different rows(countries).