If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Border Limitations for Conditional Formats
Unfortunately, we have observed that the conditional format feature appears
to limit the choices for borders. For example, the user can select both solid and broken line borders, but cannot modify the thickness of the borders as you can when in the normal cell format dialog. Is there a way to specify a conditional format that specifies a thicker border? |
#2
|
|||
|
|||
Border Limitations for Conditional Formats
Sub thickborders()
Select Case Range("a1").Value Case Is = 1: mc = 4 Case Else End Select With ActiveCell ..Interior.ColorIndex = mc ..BorderAround Weight:=xlThick End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Blue Max" wrote in message ... Unfortunately, we have observed that the conditional format feature appears to limit the choices for borders. For example, the user can select both solid and broken line borders, but cannot modify the thickness of the borders as you can when in the normal cell format dialog. Is there a way to specify a conditional format that specifies a thicker border? |
#3
|
|||
|
|||
Border Limitations for Conditional Formats
Thank you, Don, for the code to set border thickness. However, how does
this work with Conditional Formats? Can a conditional formats call up a macro? If so, is the macro applied to each cell included in the range for the conditional format rule? Finally, what is meaning of the line Case Is = 1: mc = 4 Thanks, Richard ********************** "Don Guillett" wrote in message ... Sub thickborders() Select Case Range("a1").Value Case Is = 1: mc = 4 Case Else End Select With ActiveCell .Interior.ColorIndex = mc .BorderAround Weight:=xlThick End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Blue Max" wrote in message ... Unfortunately, we have observed that the conditional format feature appears to limit the choices for borders. For example, the user can select both solid and broken line borders, but cannot modify the thickness of the borders as you can when in the normal cell format dialog. Is there a way to specify a conditional format that specifies a thicker border? |
Thread Tools | |
Display Modes | |
|
|