A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Border Limitations for Conditional Formats



 
 
Thread Tools Display Modes
  #1  
Old April 3rd, 2010, 06:49 PM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default 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?

Ads
  #2  
Old April 3rd, 2010, 08:42 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default 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  
Old April 4th, 2010, 08:32 PM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default 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?


  #4  
Old April 5th, 2010, 01:28 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default Border Limitations for Conditional Formats

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

"Blue Max" wrote in message
...
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.