I have 45 rows of data and in Column A there will be a "y" or an "n".
If there is a "y", I want the whole row to be red, if not, leave it
alone. I can do this for 1 row at a time, but I was hoping to do it
for all of the rows at the same time. I tried to use the array option,
but I could not get it to work.

Any ideas?