跨表格进行条件格式化以基于大于进行突出显示单元格 [英] Conditional formatting across sheets to highlight a cell based on greater than comparison

问题描述

假设excel中有2张纸Run1和Run2。两者都有一列说PassCount。我们如何比较Run1和Run2上的PassCount以获得更大的值，例如，如果Run2中的PassCount高于Run1的PassCount，则Run2条目应以绿色突出显示，否则应为红色

Suppose there are 2 sheets Run1 and Run2 in excel. Both have a column say PassCount. How can we compare PassCount on Run1 and Run2 for greater value such that, if PassCount in Run2 is higher than PassCount from Run1 then Run2 entry should be highlighted in green else it should be red

Run2

Run1运行1完全相同，但值不同。

Run1 Run 1 is exactly the same sheet with different values.

现在，我需要的是：If（C3 of sheet Run18> Run17的C3），然后以绿色突出显示Run18的C3，否则以红色突出显示。这将显示当前结果是否好于先前结果。

Now, what I need is: If(C3 of sheet Run18 > C3 of sheet Run17) then highlight C3 of Run18 in green else highlight it in red. This will show if the current result is better than the previous result or not.

推荐答案

绿色：

green color:

=COUNTIF(C2, ">"&INDIRECT("Run18!C2"))

红色：

red color:

=COUNTIF(C2, "<="&INDIRECT("Run18!C2"))

这篇关于跨表格进行条件格式化以基于大于进行突出显示单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！