Change Borders Color.

[XL_Newbie]

Hello-

How can I update the color of existing borders while maintaining the border formats (i.e. thickness and style).
I am attaching a sample file for testing. Thanks in advance for your help.

P.

[FDibbins]

Hilight the area you want, right click/format cells/borders...pick the color you want and apply it to the lines you want. This will not change the line thickness etc

[XL_Newbie]

Hilight the area you want, right click/format cells/borders...pick the color you want and apply it to the lines you want. This will not change the line thickness etc

Thanks FDibbins. But I am talking about thousands of cells with customized borders. I am looking for a way to automate this.
Do you know how? Thanks.

P.

[DGagnon]

there may be an easier solution, but you could use a macro like this

just need to set the colour, the bellow will make all borders red

Please Login or Register  to view this content.

[XL_Newbie]

[QUOTE=DGagnon;2717909]there may be an easier solution, but you could use a macro like this

just need to set the colour, the bellow will make all borders red

That's exactly what I need. Thanks much DGagnon. You got a star.

P.

[DGagnon]

no problem, if you need help finding a colour value please let me know. Also you may need to adjust the ranges in the loop to suit your specific needs.

[XL_Newbie]

no problem, if you need help finding a colour value please let me know. Also you may need to adjust the ranges in the loop to suit your specific needs.

Actually, yes I need your help with finding value for each color. what method do you use? Thanks.

P.

[DGagnon]

easiest way to find it would be to record a macro and manualy change one cell to the desired colour. you could then look at the recorded macro in the VB editor and look for the colour attribute. you could also use colorindex instead of color which is a set list of 56 useable colours, that would make the code look like this

Please Login or Register  to view this content.

list of colour index can be found at http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[XL_Newbie]

Thanks again for your help. I did try the macro recording first but I kept getting a value of one for the very light grey color selected then plugged in the value into the first code you sent but it didn't work.
anyway, the later code and color link you sent works fine for me. Thanks again.

P.

[DGagnon]

any time, glad to help.