条件格式，基于整行 [英] Conditional formatting, entire row based

问题描述

我已经搜索并阅读了与条件格式有关的答案，但似乎无法正常工作，所以也许我做错了事。

<我有一个工作表。它包含我们庇护所中的动物清单。我要尝试的是将整个行都用绿色（如果在 G列中用 X表示）。我有 = $ G $ 2 = X 和 = $ G2 = X ，但是都没用。设置规则时，它只会为活动的一行上色，而在另一行中输入 X时，它将不执行任何操作。我缺少什么？

解决方案

  = $ G1 = X 
  

将是正确（也是最简单）的方法。只需先选择整个工作表，因为条件格式仅适用于选定的单元格。我只是试过了，效果很好。您必须从G1而不是G2开始，否则它将使条件格式偏移一行。

I've searched and read through answers related to conditional formatting, but I can't seem to get mine to work, so maybe I'm doing something wrong.

I have a worksheet for work. It contains a list of animals in our shelter. What I'm attempting to do is color the entire row green if they've been adopted (noted by an "X" in column "G"). I've had =$G$2="X" and =$G2="X", but neither work. It'll only color the one row that was active when I set the rule, and when I enter "X" in another row, it does nothing. What am I missing?

解决方案

=$G1="X"

would be the correct (and easiest) method. Just select the entire sheet first, as conditional formatting only works on selected cells. I just tried it and it works perfectly. You must start at G1 rather than G2 otherwise it will offset the conditional formatting by a row.

这篇关于条件格式，基于整行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！