formating named range

[G2K]

Hi,

I need to format a range named ABC, ABC range starts from A1 to
c10. i want to format this range as -

Merge A1 to C1
Outline = medium
Inline = thin
bordercolor = Blue
Interior color = Green

is it possible to format range ABC acoording to above specification??

Please Help...

Thanks.

 

[iliace]

Why wouldn't it be possible? Do you mean using VBA/macro?

Or if you mean "inline" within the first row, then no - there is no borders for cells that are part of a merged cell set.