Excel 2000 Question

Hi there, hope i can get some help with this.


i have office 2007 at home and have created a sheet,....but my excel 2000 at work wont let the conditional formatting work.

i have a coloumn and i want, when the word "yes" or "handed in" for the whole line to turn blue in colour, hilighted.

i got some good help on here for the office 2007 version but alas it doenst work at work.

its basically to show when a worker hands his kit in and we type "yes" the coloums a, b, c, d, e, f, g all highlight blue.

the sheet works horizontal and A1 is monday B1 is tuesday and so on to sunday,...so if on sunday he hands his kit in then A1 all the way to G1 highlights blue.

many thanks guys