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?
 
You can choose any borders you want. Are you talking about gridlines?

Tyro
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting: changing number format 3
Border Limitations for Conditional Formats 3
Conditional Formatting for entire row 4
Conditional row format 3
Conditional Formatting - Thick Border? 6
Cut & Paste in Excel without erasing cell borders? 1
Conditioning Formatting - Thicker Borders 2
copy conditional format without using format painter 2

Back
Top