StavrosWTF
New Member
- Joined
- Nov 18, 2016
- Messages
- 3
So I want to automate some things in my excel. So what I want is for excel to automatically add borders to specific cells based on real-life date. So this is how my sheet is.
<tbody>
</tbody>So for example, let's say A2 cell's value changes to 2, then I would want the whole Week 2 column to have a thick black outside borders. However, when A2 cell's value changes to 3, I want Excel to remove the borders from Week 2 column and then add borders to Week 3 and so on... I hope you can help me with this please.
Week Number | Week 1 | Week 2 | Week 3 | Week 4 |
1,2,3,4... | ||||
<tbody>
</tbody>