Excel 2000 Question

[Closed]
Report
Posts
1
Registration date
Wednesday June 2, 2010
Status
Member
Last seen
June 21, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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