Color format Cell by duplicate character / name / value in each column / cell [closed]
How would I be able to color code each column that represent a certain name or value
example column A: mike Column B: John Column C: Dan Column D: mike Column E: Dan Column E: John
I would like all cells with the name " mike " color code RED
is there a way to do this with conditional formatting.
is there a different way?
thank you in advance for any help provided.