Noit in the cell formula but you can use Conditional Formatting to change the
color of the cell.

Format>Conditional Formatting:Formula is

=A1="Noelsy"  Format to a color.

If A1 contains Noelsy the cell will be colored.

If it contains  Gord  it will not be colored.

Or for this simple example CF>Cell Value is equal to Noelsy would return the
color if true.

Gord Dibben  MS Excel MVP