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

FormatConditional 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 CFCell Value is equal to Noelsy would return the
color if true.


Gord Dibben MS Excel MVP


On Fri, 30 Nov 2007 20:21:01 -0800, Noelsy
wrote:

Excel: In an if statement can i change cell fill or background color if correct