如果Google电子表格的同一列中的值重复，如何突出显示单元格? [英] How to highlight cell if value duplicate in same column for google spreadsheet?

问题描述

我正在寻找Google电子表格的公式 如果值在同一列中重复，则突出显示单元格

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column

有人可以协助我进行此查询吗?

can anyone please assist me for this query?

推荐答案

尝试一下:

1. 选择整个列
2. 点击格式
3. 点击常规格式
4. 点击添加另一条规则(或编辑现有/默认规则)
5. 将如果设置单元格格式设置为:Custom formula is
6. 将值设置为:=countif(A:A,A1)>1(或将A更改为您选择的列)
7. 设置格式样式.
8. 确保该范围适用于您的列(例如A1:A100).
9. 点击完成

1. Select the whole column
2. Click Format
3. Click Conditional formatting
4. Click Add another rule (or edit the existing/default one)
5. Set Format cells if to: Custom formula is
6. Set value to: =countif(A:A,A1)>1 (or change A to your chosen column)
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
9. Click Done

将检查A1:A100单元格中写入的所有内容，如果有重复项(发生多次)，则将其上色.

Anything written in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

对于使用逗号(,)作为小数点分隔符的语言环境，参数分隔符很可能是分号(;).也就是说，尝试:=countif(A:A;A1)>1，代替.

For locales using comma (,) as a decimal separator, the argument separator is most likely a semi-colon (;). That is, try: =countif(A:A;A1)>1, instead.

对于多列，请使用 countifs .

For multiple columns, use countifs.

这篇关于如果Google电子表格的同一列中的值重复，如何突出显示单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！