On Jun 27, 8:25*am, wrote:
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?

it should work if u do a paste special over the area u need
do paste special and click format. it should work
i hope lol