为什么使用自定义公式的Google文档条件格式无法正常工作? [英] Why does Google Docs Conditional Formatting with custom formula not work?
问题描述
我试图有条件地格式化一列数字,以突出显示等于最大值的数字.例如,如果该列具有这些值3,5,8,4,8,2,8,7
I am attempting to conditionally format a column of numbers to highlight those that are equal to the maximum. For example, if the column has these values 3,5,8,4,8,2,8,7
我希望对8(在第三,第五和第七行中)进行格式化.
I want the 8s (in the 3rd, 5th and 7th rows) to be formatted.
我正在选择该行,右键单击以选择条件格式",从格式单元格为..."下拉列表中选择等于",然后输入"= MAX(A1:A8)"自定义公式.
I am selecting the row, right-clicking to choose "Conditional Formatting", selecting "is equal to" from the "Format cell is..." dropdown, and typing in "=MAX(A1:A8)" for the custom formula.
等于最大值(8)的像元已正确应用了条件格式,但列中的最后一项(即7)已正确应用了条件格式 .
The cells that equal the max (8) have the conditional formatting correctly applied, but the final item in the column (the 7) has the conditional formatting incorrectly applied.
以下是屏幕截图:
这是链接到电子表格 (不可编辑).
我注意到其他数字列存在相同的问题-最大值应用了格式设置(如预期的那样),但是该列中的其他一些数字始终应用了格式错误(意外).
I've noticed the same problem with other columns of numbers — the maximum values have the formatting applied (as expected), but some other numbers in the column always have the formatting incorrectly applied (unexpected).
推荐答案
您正在使用相对寻址,因此A8中的7实际上是A8:A15的最大值.
You are using relative addressing so that the 7 in A8 is actually the maximum of A8:A15.
使用 $ 绝对锚点用=MAX(a$1:a$8)
锁定行,或者如果条件格式范围横向扩展,则使用=MAX($a$1:$a$8)
.
Use the $ absolute anchor to lock the rows with =MAX(a$1:a$8)
or if the conditional format range extends laterally, =MAX($a$1:$a$8)
.
这篇关于为什么使用自定义公式的Google文档条件格式无法正常工作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!