Fancy1, thanks for the advice very useful. using Draw Border (Home Ribbon,
Font buttons, hit the arrow with the border controls, go to Line Style, click
the thick one and then use Draw Border) on the selected cells which have
conditional formatting can overide and use thick formats. A bit manual but
exactly what i needed, thanks

"Debra Dalgleish" wrote:

The message about using the Draw Borders toolbar was from Fancy1, not
from me. And it doesn't help with conditional formatting of borders.