Forum Discussion
Solved
Conditional formatting for multiple comma separated entries
I have a list of comma separated values. I would like the change the background colour of all the cells that contains any of those values in an excel sheet. My list -> 152,677558,662883,32737737....
AkA2000 Rather than using a coma separated list in one cell, consider using numbers in a range of cells. Then you can easily use conditional formatting to highlight matching numbers. See attached.
AkA2000 Rather than using a coma separated list in one cell, consider using numbers in a range of cells. Then you can easily use conditional formatting to highlight matching numbers. See attached.