Excel 2000 Question

Closed
dbstan Posts 1 Registration date Wednesday June 2, 2010 Status Member Last seen June 21, 2010 - Jun 21, 2010 at 10:57 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 21, 2010 at 05:42 PM
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

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 21, 2010 at 05:42 PM
Could you please upload a sample file with sample data, CONDITIONAL FORMAT formula etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0