find/replace cell borders

[Steve]

Is it possible to change in an entire sheet at one time any double line
border (right, left, top, or bottom) with a single line border?

 

[FSt1]

hi
call the find dialog(ctrl+F)
click the replace tab
click the options button
on the find what line, click the format button and set the format you wish
to find
on the replace line, click the format button and set the format you wish to
replace.
click replace all

Regards
FSt1

 

[Steve]

That works if you're very specific on what you're finding/replacing. In my
case I have double line borders on the right and single lines on the other
sides; double borders on the top and no other borders; and so on. Isn't
there an easier way to just replace any double line border with a single
line? Other than having to do find/replace with every possible combination?