Forum Discussion
colour formatting to text
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)
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-66a552dc138dUse 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).
- Can you perhaps attach an anonymized example file? I find it hard to picture what you need.
