change colors
 

Have the following formula and if a "p" is inserted, I want the color of the
cell to be green(ok), if "x" red(problem).
=IF(C66="","",IF(C66=$B66,"p","x"))

I saw this somewhere but can't find.

Thanks,
L.

change colors
 

Look at format|conditional formatting.

"L." wrote:

Have the following formula and if a "p" is inserted, I want the color of the
cell to be green(ok), if "x" red(problem).
=IF(C66="","",IF(C66=$B66,"p","x"))

I saw this somewhere but can't find.

Thanks,
L.

--

Dave Peterson

change colors
 

Thanks, that's it.
L.

"Dave Peterson" wrote in message
...
Look at format|conditional formatting.

"L." wrote:

Have the following formula and if a "p" is inserted, I want the color of
the
cell to be green(ok), if "x" red(problem).
=IF(C66="","",IF(C66=$B66,"p","x"))

I saw this somewhere but can't find.

Thanks,
L.

--

Dave Peterson