Hi David

this can (easily) be achieved using conditional formatting
select cell 1
choose
format / conditional formatting
choose formula is
type
=A1="Y"
in the box where A1 is the cell reference of your cell 2
click on the format button - set the format you want, click OK
then click on Add
choose
formula is
type
=A1="N"
click on the format button - set the format you want, click OK
click on OK again

Cheers
JulieD


"David Campbell" <David wrote in message
...
I need a Macro in Excel that will change the color of cell #1 when a Y or
N
is entered into cell #2.