Hi!
Please help me woth the following problem (it starts with B2):
<tbody>
</tbody>
I'd like to lock the entire rows where the "Date" column is smaller than the "Today" column, in this example, only the Contract no. 5 could be modified. This should go up to 2000 rows.
Thank you!
Please help me woth the following problem (it starts with B2):
Contract no. | Date | Today | Partner company | Merchandise | Shipping date | Adjustments | Etc.1 | Etc.2 | Etc.3 | Etc.4 | Etc.5 | Etc.6 | Etc.7 |
1 | 2014.02.12 | 2014.09.18 | XYZ Inc. | Books | 2014.02.26 | No | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
2 | 2014.03.13 | 2014.09.18 | ASD Co. | Food | 2014.03.27 | No | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
3 | 2014.07.12 | 2014.09.18 | FYI Inc. | Cars | 2014.07.26 | No | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
4 | 2014.08.19 | 2014.09.18 | LOL Co. | Pens | 2014.09.02 | Shipment changed | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
5 | 2014.10.01 | 2014.09.18 | TBA Inc. | Jokes | 2014.10.15 | No | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
…. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. |
2000 | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. | …. |
<tbody>
</tbody>
I'd like to lock the entire rows where the "Date" column is smaller than the "Today" column, in this example, only the Contract no. 5 could be modified. This should go up to 2000 rows.
Thank you!