单元格处于活动状态时突出显示整行 [英] Highlight entire row when cell is active

问题描述

如何设计工作表脚本，使活动行突出显示?

How to design a sheet script that would result in an active row being highlighted?

当该行中的一个单元处于活动状态时，我希望整行更改字体或背景的颜色.

I would like to have an entire row change color of font or background when one cell in that row is active.

我不希望触发器是该单元格中的任何特定值，只需单击一个单元格即可触发该单元格所属的整行的高亮显示.

I don't want the trigger to be any specific value in the cell, just clicking on a cell should trigger the highlight for the whole row that cell belongs to.

推荐答案

对不起，仅选择一个单元格就不能通过条件格式或脚本来完成.但是，您可以使用组合键Shift-空格键突出显示活动单元格的整个行.

Sorry, this can't be done with conditional formatting or script by just selecting a cell. You can, however, highlight an entire row of the active cell with the key combination Shift-Spacebar.

这篇关于单元格处于活动状态时突出显示整行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！