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)
Forum Discussion
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-66a552dc138d
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!!!