highlite the area you want the conditional format

at the menus select format,
and then conditional formatting
select, cell value is
go to the next drop down box and select equal to
go to the next box and type in Y ,
press the format button
select patterns
select the color you want
press ok a couple of times
test it out
Dave