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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 12, 2016 at 06:58 AM
Related:
- Change color of text or cell if the value entered is same
- Notepad++ change background color - Guide
- Change computer name cmd - Guide
- Html text color - Guide
- Change name of lg tv - Guide
- How to change number of best friends on snapchat - Guide
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
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
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