Google表格上的条件格式取决于其他表格中的单元格 [英] Conditional Formatting on Google Sheets depending on cell in other sheet

问题描述

所以我有一个表是时间轴，第一列是日期的升序列表，第二列是该日期发生的事件的描述.

So I have one sheet that's a timeline, with the first column being an ascending list of dates and the second being a description of the event that happens on that date.

另一张纸上有一个带有特定日期的单元格.

Another sheet has a cell with a specific date.

我希望第一张工作表的第一列上的单元格的日期是第二张工作表的单元格上要格式化的日期.我该怎么办?

I would like the cell on the first column of the first sheet whose date is the date on that second sheet's cell to be formatted. How do I do that?

推荐答案

如果第二张工作表的单元格A1中有一个日期，则第一张工作表的第一列应采用条件格式值等于...". c0>

If the second sheet has a date in cell A1, then the first column of the first sheet should have conditional formatting "Value is equal to... " =indirect("Sheet2!A1")

必须使用indirect，因为否则条件格式设置规则将无法引用其他工作表.

The use of indirect is necessary because otherwise conditional formatting rules cannot refer to other sheets.

这篇关于Google表格上的条件格式取决于其他表格中的单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！