Excel - 如果文本存在则底部边框?
我现在正在创建一张发票,每张发票上都会有不同数量的文本。
理想情况下,我希望能够输入内容,一旦我这样做,它就会沿着该行的底部创建一个边框,从 A 到 K(如果有意义的话)。
这可能吗?
干杯:)
I'm creating an invoice at the moment, and there's going to be varying amounts of text on each invoice.
Ideally I'd like to be able to enter content, and as soon as I do that, it'll create a border along the bottom of that row, from A to K if that makes sense.
Is this possible?
Cheers :)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
不是严格编程...您可以选择从 A1 到 Kn 的单元格,然后转到“格式”>“条件格式。选择“公式为”,输入=$A1>>“”。单击格式并设置边框。
现在,如果您在 col 中的单元格中输入文本。 A,该行将在 K 列之前加下划线。由于不熟悉发票,我只能希望这就是您想要的:)
Not strictly programming... you can select the cells from A1 to Kn then go to Format > Conditional Formatting. Select "Formula Is", enter =$A1<>"". Click format and set the border.
Now if you enter a text to a cell in col. A, that row will be underlined up to column K. Not being familiar with invoices I can only hope this is what you wanted :)
条件格式可能适合您:
示例 #1
示例#2
在你的情况下,(如果我理解正确的话)您将突出显示从 A1 到 K10 的所有单元格(假设最多十行),然后按如下所示制作条件格式公式:
然后只需在“格式...”选项中设置边框即可应用边框,如例子。
Conditional formatting might do the trick for you:
Example #1
Example #2
In your case, (if I understand you right) you would highlight all cells from A1 to K10 (assuming a maximum of ten rows), and then make the conditional formatting formula as follows:
Then just apply the border by setting it up in the "Format..." options as shown in the examples.