Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 343
Default Borders and conditional formating

I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default Borders and conditional formating

You can choose any borders you want. Are you talking about gridlines?

Tyro

"Patrick C. Simonds" wrote in message
...
I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 343
Default Borders and conditional formating

I am talking about Borders in conditional formatting. I see no way to
increase the weight of the line.


"Tyro" wrote in message
t...
You can choose any borders you want. Are you talking about gridlines?

Tyro

"Patrick C. Simonds" wrote in message
...
I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default Borders and conditional formating

hi.
and you wont. conditional formatting has it restrains. what you see is what
you get.
submit a suggestion to micorsoft. speaking of 03 and back. i haven't work
with 07 yet.
why has this issue got you so wired up????

regards
FSt1

"Patrick C. Simonds" wrote:

I am talking about Borders in conditional formatting. I see no way to
increase the weight of the line.


"Tyro" wrote in message
t...
You can choose any borders you want. Are you talking about gridlines?

Tyro

"Patrick C. Simonds" wrote in message
...
I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?





  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 860
Default Borders and conditional formating

Hi Patrick,

From the Help file
Why cant I use all formats as conditional formats?

Cell formats that can change the row height or
column width cannot be used as conditional formats


Makes sense when you think about it. It would
play havoc with your neatly formatted sheet.

HTH
Martin


"Patrick C. Simonds" wrote in message
...
I am talking about Borders in conditional formatting. I see no way to
increase the weight of the line.


"Tyro" wrote in message
t...
You can choose any borders you want. Are you talking about gridlines?

Tyro

"Patrick C. Simonds" wrote in message
...
I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 343
Default Borders and conditional formating

Not really wired up, had just hoped to define a border for a set of column
as I completed rows.

Each occurrence of the worksheet could have a different number of rows so I
was hoping to use a conditional format to move the border down one row at a
time as the rows were populated. So if I completed say row 89 the border
would be extended down to row 90.




"FSt1" wrote in message
...
hi.
and you wont. conditional formatting has it restrains. what you see is
what
you get.
submit a suggestion to micorsoft. speaking of 03 and back. i haven't work
with 07 yet.
why has this issue got you so wired up????

regards
FSt1

"Patrick C. Simonds" wrote:

I am talking about Borders in conditional formatting. I see no way to
increase the weight of the line.


"Tyro" wrote in message
t...
You can choose any borders you want. Are you talking about gridlines?

Tyro

"Patrick C. Simonds" wrote in message
...
I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating borders via Conditional Formatting WLMPilot Excel Discussion (Misc queries) 1 November 8th 07 12:33 AM
Conditional Borders? MarcoPolo Excel Discussion (Misc queries) 1 January 9th 07 03:39 PM
Conditional Formatting of merged cells, borders don't show correct pablo Excel Discussion (Misc queries) 5 September 21st 06 09:23 PM
Merged Cell Conditional Formatting Borders T Kirtley Excel Discussion (Misc queries) 2 June 1st 06 07:38 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"