来自另一张纸的条件格式 [英] Conditional Formatting from another sheet

问题描述

我正在尝试在工作表 A 上检查一个单元格是 > 还是 <表 B 上单元格中的值，然后相应地更改其颜色.在我使用的自定义公式下:=A1>("SheetB!A1")，但它似乎不起作用.我对 > 使用绿色，对 <使用红色.每次保存规则时，它总是在工作表 A 上以红色显示 A1.

I'm trying to have a cell on Sheet A check if it's either > or < the value in a cell on Sheet B, then change its color accordingly. Under the custom formula I use: =A1>("SheetB!A1"), but it doesn't seem to work. I use the color Green for the > and the color Red for the <. Every time the rules are saved it will always display A1 on Sheet A in red.

是函数出错了吗?还是不可能有条件格式甚至跨工作表搜索?

Is the function wrong? Or is it not possible to have a Conditional Format even search across sheets?

推荐答案

出于某种原因(我承认我真的不知道为什么)条件格式中的自定义公式不直接支持跨表引用.

For some reason (I confess I don't really know why) a custom formula in conditional formatting does not directly support cross-sheet references.

但支持跨表引用间接-ly:

But cross-sheet references are supported INDIRECT-ly:

=A1>INDIRECT("SheetB!A1")

或者如果您想将 SheetA 上的 A1:B10 与 SheetB 上的 A1:B10 进行比较，请使用:

or if you want to compare A1:B10 on SheetA with A1:B10 on SheetB, then use:

=A1>INDIRECT("SheetB!A1:B10")

=A1>INDIRECT("SheetB!"&CELL("address",A1))

适用于范围 A1:B10.

applied to range A1:B10.

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