Conditioning Formatting - Thicker Borders

  • Thread starter Thread starter Fancy1
  • Start date Start date
F

Fancy1

I discovered that if you click on the Borders icon on the Formatting
toolbar, after you have created your Conditioning Formatting, click on
Draw Borders . . . you can change the borders as thick as you want. Use
the slide bar and scroll down to select the border you want. You will
have many to choose from.

Yes, you will have to go over & trace each cell by hand, but the borders
are definitely thicker!!
 
You could do this with a macro. From vba help

Worksheets("Sheet1").Range("A1:D4").BorderAround _
ColorIndex:=3, Weight:=xlThick
 
What happens when the cell value no longer meets the conditions for
borders? Do you manually remove the thick lines?
 
Back
Top