Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Color format Cell by duplicate character / name / value in each column / cell

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.