I am looking for formula to highlight cell if there is duplicate values in column.
Can anyone please assist me for this query?
Thanks in advance!
How to highlight cell if there are duplicate values in same column?
-
erickner93
- Mesaje: 2
- Membru din: Joi Iul 18, 2019 3:20 pm
Re: How to highlight cell if there are duplicate values in same column?
Hi,
Try Conditional Formatting
Select the range then Home-Styles-Conditional Formatting-Highlight Cells Rulles-Dupliates Values
Try Conditional Formatting
Select the range then Home-Styles-Conditional Formatting-Highlight Cells Rulles-Dupliates Values
Nu aveţi permisiunea de a vizualiza fişierele ataşate acestui mesaj.
Am invatat sa inotam in apa, ca pestii
Am invatat sa zburam in aer, ca pasarile
A ramas doar sa invatam sa traim pe Pamant, ca Oamenii.
Am invatat sa zburam in aer, ca pasarile
A ramas doar sa invatam sa traim pe Pamant, ca Oamenii.
-
Indigo-ONE
- Mesaje: 435
- Membru din: Mar Dec 11, 2018 8:54 pm
Re: How to highlight cell if there are duplicate values in same column?
Daca vrei evidentierea celulei cu dubluri, aceasta se poate face cu Conditional Formating.
O formula nu poate colora o celula (formulele nu pot modifica formatarea celulelor).
O formula nu poate colora o celula (formulele nu pot modifica formatarea celulelor).
藍
"I fear the day that technology will surpass our human interaction. The world will have a generation of idiots."
Albert Einstein
"I fear the day that technology will surpass our human interaction. The world will have a generation of idiots."
Albert Einstein
-
erickner93
- Mesaje: 2
- Membru din: Joi Iul 18, 2019 3:20 pm
Re: How to highlight cell if there are duplicate values in same column?
It worked. Thanks!
