Borders and conditional formating

[Patrick C. Simonds]

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

 

[Tyro]

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

Tyro

 

[Patrick C. Simonds]

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

 

[FSt1]

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

 

[MartinW]

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]

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.