Hi All,
I have a bit of a detailed request for help, so i will try to explain it as best i can.
I have a table whereby users must add a new line to the table each time they complete a project. Within this line they must enter their project reference, and then the names of people responsible for the 5 tasks detailed in the headings of the table.
When entering a new line i have the following set of criteria:
1. Column G, H, I, J and K must be filled in (baring in mind that this only applies if a project code has been entered in column C).
2. Column H and I cannot be the same
3. If G and H are the same, then K must be different.
You can see how i have this set up currently in the sample below. But this does not prevent people from leaving cells blank to over-ride the validation checks.
http://dl.dropbox.com/u/18993939/SOD%20Sample.xls
I hope this makes sense and thanks in advance for your help.
I have a bit of a detailed request for help, so i will try to explain it as best i can.
I have a table whereby users must add a new line to the table each time they complete a project. Within this line they must enter their project reference, and then the names of people responsible for the 5 tasks detailed in the headings of the table.
When entering a new line i have the following set of criteria:
1. Column G, H, I, J and K must be filled in (baring in mind that this only applies if a project code has been entered in column C).
2. Column H and I cannot be the same
3. If G and H are the same, then K must be different.
You can see how i have this set up currently in the sample below. But this does not prevent people from leaving cells blank to over-ride the validation checks.
http://dl.dropbox.com/u/18993939/SOD%20Sample.xls
I hope this makes sense and thanks in advance for your help.