Automate Trigger Borders in Excel

[Sam Lam]

Hi all,

I am currently working on this heatmap work sheet, which is project management related. Coming from a shaky Excel background, I do hope that people here can enlighten me on:
1. The user will input the starting date and the finish date of the project in column I and J respectively and based on the number of days, I need to automate the trigger of the boxes accordingly as shown in the picture. (Eg: If project start = 5 Aug, project end = 7 Aug, how can I trigger 3 columns of borders?)

2. Colouring the boxes triggered in (1) accordingly.

Thanks everyone in advance (

 

[Herakles]

Hi all,

I am currently working on this heatmap work sheet, which is project management related. Coming from a shaky Excel background, I do hope that people here can enlighten me on:
1. The user will input the starting date and the finish date of the project in column I and J respectively and based on the number of days, I need to automate the trigger of the boxes accordingly as shown in the picture. (Eg: If project start = 5 Aug, project end = 7 Aug, how can I trigger 3 columns of borders?)

2. Colouring the boxes triggered in (1) accordingly.

Thanks everyone in advance (View attachment 97344

What row are the dates being entered into?

Is the structure you show above on the same worksheet?

What column and row does the structure start on?

Is it just the borders and colouring that you need or the contents as well?

Will the user be changing the date range and therefore the structure needs to change?

 

[Peter_SSs]

as shown in the picture. (Eg: If project start = 5 Aug, project end = 7 Aug,

The picture does not show the 5 Aug to 7 Aug date range.
How is this essentially different to your other thread other than this is borders instead of colouring the cells?

 

[Sam Lam]

What row are the dates being entered into?

Is the structure you show above on the same worksheet?

What column and row does the structure start on?

Is it just the borders and colouring that you need or the contents as well?

Will the user be changing the date range and therefore the structure needs to change?

Here's the screenshot of my sheet. The user can change the date range.

 

[Peter_SSs]

How is this essentially different to your other thread other than this is borders instead of colouring the cells?

You did not answer this question, but looking at your new picture and reading your request again it appears to be essentially the same question, the only change being borders instead of cell colour.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so if further help is needed please continue in the linked thread.