如果另一张工作表中的相同单元格不为空，则Google将条件格式设置为彩色单元格 [英] Google sheets conditional formatting to colour cell if the same cell in another sheet is not empty

问题描述

我有2张纸 A 和 B .如果工作表B 中完全相同的单元格不为空，我希望工作表A 为单元格着色.例如，如果工作表B 中的单元格 A1 有一个字符串，则工作表A 中的单元格 A1 将会是彩色的.

假设我想这样做是为了比较大范围，我应该如何去做呢?

示例:

I have 2 sheets A and B. I want sheet A to colour cells if the exact same cell in sheet B is not empty. For example if cell A1 in sheet B has a string, then cell A1 in sheet A will be coloured.

Let's say I want to do this to compare a large range, how should I go about doing this?

Example: https://docs.google.com/spreadsheets/d/1P3Ob_mclpXWmILfKwD4R6JN2wAYPUcNZlmtF9LxilV0/edit?usp=sharing

Cells A2:C2, D5 and K2 in sheet B are not empty. So the corresponding cells in sheet A will be coloured red.

解决方案

You can use the following formula as a conditional formatting rule:

=NOT(ISBLANK(INDIRECT("B!"&address(row(),column()))))

(the formula in A!A2 is there to just show you what happens in sheet B)

这篇关于如果另一张工作表中的相同单元格不为空，则Google将条件格式设置为彩色单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！