Conditional formatting (bottom & top border)

[muhammad susanto]

hello all,

i hope you could help me about conditional formatting border (top & bottom), for this below :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]seq number (col.a)
[/TD]
[TD]data (col.b)
[/TD]
[/TR]
[TR]
[TD]1.
[/TD]
[TD]george
[/TD]
[/TR]
[TR]
[TD]2.
[/TD]
[TD]mike
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3.
[/TD]
[TD]evan
[/TD]
[/TR]
[TR]
[TD]4.
[/TD]
[TD]john
[/TD]
[/TR]
[TR]
[TD]etc..
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

how to add border with condition ;
for number 1.---------put border top & bottom
2.---------put border bottom
3.---------put border top & bottom
4.---------put border bottom

it's possible??

thanks!!

 

[bbott]

Hello,

Assuming the number 1 is in cell A2, enter this formula in the conditional formatting formula box:

=AND(A1<>"",A2<>"")

Copy the formatting down as fars as you would like.

 

[muhammad susanto]

thank you very much, bbott..

 

[bbott]

You're welcome!