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)
5 Replies
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.
- -2 columns of country and cities are there I want rows having same country same color and different color for different rows(countries).
- 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).
- I was looking for a formula and when I read your solutions it was just soooooo simple and it works!!!
- Can you perhaps attach an anonymized example file? I find it hard to picture what you need.
