change grid color

Hi,

There are two Tables in my Excel sheet.
one is control table and the other is presentation table.
I would like to change presentation Table's grid color by control Table.
(as attachment)

It seems it cannot achieve by formula only, probably the VBA is necessary to use.
Could anyone give me hint?
Thank you!

B.R.
YU

Why not RIGHT CLICK in Table (after selecting all cells), then FORMAT CELLS / BORDER. SELECT the line type and color, then click OK.

There's over hundred lines of control table.
And presentation table is generated by another tool.
I would like it automatically mark color but by manually.

Hi,

should be better with the expected color in column A or D for example …

According to the attachment a VBA demonstration as a beginner starter :

PHP Code: 

Sub Demo1()
        C% = 2
    For R& = 3 To [A1].End(xlDown).Row
        If C < 51 Then C = C + 1 Else C = 3
        Range(Cells(Cells(R, 1) + 2, 13 - Cells(R, 2)), Cells(Cells(R, 1) + 2, 13 - Cells(R, 3))).Interior.ColorIndex = C
    Next
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Hi Mark.

It works, thank you so much.

I have advance question:
I see C%, R& in your code. What does it mean?

Appreciated with you help.

Originally Posted by okeyla

Hi Mark.

I see C%, R& in your code. What does it mean?

BASIC legacy to declare a variable type like described in previous post …

Originally Posted by Marc L

BASIC legacy to declare a variable type like described in previous post …

Hi Marc:

Sorry and thank you for helping.