用googlespreadsheet突出显示重复行 [英] Highlight Duplicate row with googlespreadsheet
问题描述
我试图突出显示下表中的重复行. 目的是仅使用Google Spreadsheet突出显示缺席超过2天的学生.数据已经被修改,只能捕获其中的一部分.
I'm trying to highlight the duplicate row for the following table. The purpose is to highlight the student that is absent in more than 2 days using Google Spreadsheet only. The data already modified and only captures a few of them.
|------------|-------------|-------------|-------------|------------|
| Day 1 | Day 2 | Day 3 | Day 4 | Day 5 |
|------------|-------------|-------------|-------------|------------|
|John |John |Dandy |Yuri G |John |
|Apppleton |Appleton |Appleton |Anton Doyle |Appleton |
|Yuri G |Chris |John |Appleton |Yuri G |
|Anton Doyle |Anton Doyle |Anton Doyle |Asanka |Anton Doyle |
|Boyle |Boyle |Yuri G |Reeta |Asanka |
这是预期的输出
标准是,如果学生缺席2天,突出显示将变为绿色.如果3天,它将突出显示黄色.如果4天或更长时间将以红色突出显示.
可以在Google电子表格中使用条件格式设置吗?
我已经尝试了=countif(A:C,"John")>2
3天以上.但是,该公式突出显示了A:C
中的所有列.请对此提出任何建议.谢谢
The criteria is, if the student absent for 2 days, the highlight will turn green. If 3 days, it will highlight yellow. If 4 days or more will highlight red.
is this possible using conditional formatting in google spreadsheet?
I have tried =countif(A:C,"John")>2
for more than 3 days. However the formula highlights all of the column in A:C
. Kindly expect any recommendation for this. thanks
推荐答案
我相信,如果满足任何一个条件,默认情况下Google Spreadsheet就会停止.
I believe, the Google Spreadsheet by default stops if any one criteria meets.
您可以单击此处来检查公式.
单击单元格A2并按给定顺序输入以下公式,然后选择相应的颜色.使用添加规则"添加每个规则.
Click on the cell A2 and enter the below formulas in the given order and select corresponding color. Use 'Add Rule' to add each of these rules.
=COUNTIF($A$2:$E$100,A2)>3
=COUNTIF($A$2:$E$100,A2)>2
=COUNTIF($A$2:$E$100,A2)>1
这篇关于用googlespreadsheet突出显示重复行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!