In EXCEL, I want to change the cell color to reflect the text value. Like if
the cell contains "John", I want the cell color to be green, if "Bob", the
cell color to be Blue, if "Frank", purple, if "Joe", red, etc. I want to be
able to display about 18 different colors. Conditional Formatting has a
limitation of three if conditions. Thanks for your help.