Hey guys I wonder if someone would be able to help me.

I am currently trying to create a table in Excel. I have managed to create the table but now I have hit an impasse. I am trying to set it up, so that whenever I enter ONLY the letters of "Y" or "N", the table boxes are highlighted green for a Y, and red for an N.

I thought I had managed to do it, but then when I was typing things into the other boxes, if any word had an N or a Y in it, these boxes would be altered to the appropriate color too and my table turned into reds and greens all over the shop

Can anyone offer any assistance with this? I hope i've explained it properly. Oh, and I am using Excel 2007 too


Thanks guys.