I have two columns in Excel as shown on the picture below.
我在Excel中有两列,如下图所示。
I need to apply conditional formatting in this way:
我需要以这种方式应用条件格式:
if row in B column contain "1", the cell A on the same row should change its color. This needs to be applied only for the cell in A column, not whole row. Is there any option how to do this?
如果B列中的行包含“1”,那么在同一行上的单元格应该改变它的颜色。这只需要应用于列中的单元格,而不是整个行。有什么办法吗?
1 个解决方案
#1
18
Follow these steps and your problem will be solved ;)
遵循这些步骤,你的问题就会得到解决;
- Set your formula to
=$B2=1
- 将公式设为=$B2=1
- Select the fill color
Yellow
- 选择填充颜色黄色
- Applies to
=$A$2:$A$7
- 适用于= $ $ 2:$ 7美元
- Once you click Apply, make sure your formula hasn't changed! (always happens to me)
- 一旦你点击应用,确保你的公式没有改变!(总是发生在我身上)
#1
18
Follow these steps and your problem will be solved ;)
遵循这些步骤,你的问题就会得到解决;
- Set your formula to
=$B2=1
- 将公式设为=$B2=1
- Select the fill color
Yellow
- 选择填充颜色黄色
- Applies to
=$A$2:$A$7
- 适用于= $ $ 2:$ 7美元
- Once you click Apply, make sure your formula hasn't changed! (always happens to me)
- 一旦你点击应用,确保你的公式没有改变!(总是发生在我身上)