Borders and conditional formating

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

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?
 
I am talking about Borders in conditional formatting. I see no way to
increase the weight of the line.
 
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
 
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
 
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.
 
Back
Top