Change color of text or cell if the value entered is same

Closed
Mark - Jul 12, 2016 at 06:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 12, 2016 at 06:58 AM
Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before.

Ex. I wanted the font or cell become red if the name "Peter" already exists in a column. So that I would know that the entry already exists or was doubled.

Thank you so much.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 12, 2016 at 06:58 AM
Mark, Good morning.

Suppose your data is at A1:A10

Try to use:

Select A1:A10

Conditional Formating:
Formula:
=COUNTIF($A$1:$A$10,A1)>1

Choose the color RED for FILL COLOR.

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0