Excel 2007 : conditional formatting

[APPLEBEE]

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

[inesi]

Hi APPLEBEE, is that what you need (see attached)? Please notice I did the conditional formating from cell A3 to J19. If you want to understand the rule used, please select A3:J19 and open in the conditional formating tool.

I have Excel 2007 but saved the file in 2003 format, I hope it will work when opening on 2003.

[APPLEBEE]

Hi APPLEBEE, is that what you need (see attached)? Please notice I did the conditional formating from cell A3 to J19. If you want to understand the rule used, please select A3:J19 and open in the conditional formating tool.

I have Excel 2007 but saved the file in 2003 format, I hope it will work when opening on 2003.

Somehow nothing happens withthe same kind of formula in conditional formatting in 2007
is there something i am mising ?
please see the attached file for columns ag44 to ag471

thanks

[APPLEBEE]

thanks i appreciate ur help i could figure out why i was not able to , instead of two cf i used only one cf and let overwrite the default which was a normal formatting of cells

ur idea really helped a lot

thanks once again