从另一个工作表进行条件格式化 [英] Conditional Formatting from another sheet
问题描述
我试图在表单A上有一个单元格,检查它是否是>或<表B中单元格中的值,然后相应地更改其颜色。在自定义公式下使用: = A1>(SheetB!A1)
,但它似乎不起作用。我使用绿色为>,红色为<。。每次保存规则时,它总是以红色在工作表A上显示A1。
功能是否错误?或者是不可能有一个条件格式甚至搜索表单?
由于某种原因(我承认我没有真的知道为什么)条件格式中的自定义公式不直接支持跨页参考。
但支持跨页引用 INDIRECT -ly:
= A1> INDIRECT(SheetB!A1)
或者如果要比较SheetA上的A1:B10和A1:B10 SheetB,然后使用:
= A1> INDIRECT(SheetB!A1:B10)
适用于范围A1:B10。
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.
But cross-sheet references are supported INDIRECT-ly:
=A1>INDIRECT("SheetB!A1")
or if you want to compare A1:B10 on SheetA with A1:B10 on SheetB, then use:
=A1>INDIRECT("SheetB!A1:B10")
applied to range A1:B10.
这篇关于从另一个工作表进行条件格式化的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!