Excel 2007 : conditional formatting

Hi
I am very new to excel

i need to do condtional formatting , i know that since i have cols with values

say(A1:J1)

Y Y Y Y Y N N N N N

i have values in rows X cols as (i.e A5:J10)

10 20 30 40 50 60 70 80 90 10
10 20 30 40 50 60 70 80 90 10
10 20 30 40 50 60 70 80 90 10
10 20 30 40 50 60 70 80 90 10
10 20 30 40 50 60 70 80 90 10
10 20 30 40 50 60 70 80 90 10


now BASED on (A1:J1) whether Y or N and these are subject to change , these are dynamic
for example the row might be random like this
Y Y Y Y Y N N Y N Y
OR
ANYTHING

N N Y N Y N N N N N
and so on...
I want the cells to be formatted with say yellow for Y and green for N
note: let me also explain that the values inthese cells are dynamic they are based onthe programming behind and the no of rows may change

the columnrange remains the same though
please advice with an example so it teaches me to hanldle diff other situations in next projects
all help is appreciated
thanks