Conditional Formatting to Change Bordered Cell Line Width??

[Bill Weylock]

This great big sheet of tables I¹ve been boring people about has about 140
tables, which have thick black borders around each cell.

Cells between tables are not bordered.

I want to make the heavy borders go away and be replaced by the thinnest
solid line borders, and I do not want to add borders to cells that currently
do not have them.

Seems to me that condtionial formatting might be my friend here, but I can¹t
figure out how to use it.

I was trying this:

Condition 1: If Cell Value Is equal to =ISTEXT, then Format is Border/box

Condition 2: If Cell Value Is equal to =ISNUMBER, then Format is Border/box

What I would love to see is If Cell Value Is not equal to BLANK, then format
is Border/Box.

Can someone help me understand if this is possible and what (if so) I am
doing wrong. I¹m sure it¹s obvious to you, and I will cheerfully accept
humiliation if I get an answer as well.

Thanks!


Best,


- Bill


Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[Peo Sjoblom]

Select the range in question with either the mouse or the arrow keys while
holding down shift,
assume you selected from A2 to G140, then A2 would be the active cell,
instead of using cell value use
formula is and in the box type



=A2<>""

click the format button and select the borders you want and then click OK
twice

that will change for all cell relatively so in G140 it will say

=G140<>""

meaning is not blank

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Bill Weylock]

Thanks very much.

It does work exactly as you say; and if there were any justice, I would be
fine.

Unfortunately, merged cells, of which there are plenty, do not respond.

Is there any function that identifies formatting? The only way to do this,
I¹m afraid, is to identify cells that already have borders and change only
the borders they already have. I¹m guessing that is ridiculous?

What I see after running the formatting condition are cells that have a
light border on left and top (for example) and heavy borders on bottom and
right.

Phooey on merged cells anyway, but when you¹re doing tables they are
inevitable I think.

Thanks again Peo. This is beginning to look like a fools errand (set by me
for me).


Best,


- Bill

Select the range in question with either the mouse or the arrow keys while
holding down shift,
assume you selected from A2 to G140, then A2 would be the active cell,
instead of using cell value use
formula is and in the box type



=A2<>""

click the format button and select the borders you want and then click OK
twice

that will change for all cell relatively so in G140 it will say

=G140<>""

meaning is not blank

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[Peo Sjoblom]

I never use merged cells anymore, there are so many drawbacks. The only
reason for them is the layout which
mostly can be overcome by using multiple non merged cells and center across
selection, remove the grid lines using borders.
And having to fix workbooks with merged cells made by someone else is
hellish

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Bill Weylock]

That¹s about what I figured.

Thanks.


Best,


- Bill

I never use merged cells anymore, there are so many drawbacks. The only
reason for them is the layout which
mostly can be overcome by using multiple non merged cells and center across
selection, remove the grid lines using borders.
And having to fix workbooks with merged cells made by someone else is
hellish

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003