It is in lieu of a macro which may not be called by CF. However, it can be
automatic if part of a worksheet_change event macro in the sheet module. IMO
it's better than cluttering up with CF. the case was to show the possible
ways to set the color. If all else fails>>>
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Blue Max" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>> (E-Mail Removed)
>> "Blue Max" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> 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?
>>
Similar Threads
