Create A Dynamic Border Using Excel Native Formula

[mahmoud-lee]

Can I do this frame in any place and any cell by formula

[Rick Rothstein]

Put this formula in A1 and copy it across to O1, then copy A1:O1 down as far as you will want the rows to ever be filled to...

=IF(OR(ROW()>$Q$1,COLUMN()>$P$1),"",IF(OR(ROW()=1,ROW()=$Q$1),REPT($R$1,2),IF(OR(COLU MN()=1,COLUMN()=$P$1),REPT($R$1,2),"")))

[mahmoud-lee]

Great ..Great
You are a genius

[Rick Rothstein]

You have overstated my abilities by quite a lot, but I do appreciate the sentiment, so I will simply say "thank you".

[mahmoud-lee]

"thank you"