Clever Geek Handbook

Excel - bottom border if text is present?

I am creating an invoice for now and each invoice will display a different amount of text.

Ideally, I would like to be able to inject content, and once I do, it will create a border at the bottom of that line, from A to K, if that makes sense.

Is it possible?

Cheers :)

+2


source to share


2 answers


Not strict programming ... you can select cells A1 to Kn then go to Format> Conditional Formatting. Select "Formula Is", enter = $ A1 <> "". Click format and set the border.



Now if you enter text into cell col. A, this line will be underlined up to column K. Not familiar with billing, I can only hope this is what you wanted :)

+4


source


Conditional formatting can do the trick for you:

Example # 1
Example # 2

In your case (if you understand correctly) you would highlight all cells from A1 to K10 (assuming a maximum of ten rows) and then conditionalize the formatting like this:



=AND(NOT(ISBLANK(A1)),ISBLANK(A2))

Then just apply the border by setting it in the "Format ..." options, as shown in the examples.

+1


source






More articles:


All Articles