M
Muhammad Jawad Mirza
Dear Scott,
I think instead of Conditional Formatting you should use
the Data Validation Approach. This is more closer to your
requirement.
Now follow these steps:
1- Select complete Column A by clicking on the column
letter A. (you may also select a range as per requirement)
2- From Menu click Data > Validation
3- Under Settings Tab. Select Custom from the Allow box.
4- Now type the formula in Formula text box as
=COUNTIF($A:$A,A1)<2
(Optional from 5 to 7)
5- Under Input Message Tab :
Title = Scott's Check Post
Input Message = Avoid Duplication
6- Under Error Alert Tab :
Style = Stop (or Warning or Information)
7- Title = Worng Entry
Error Alert = Scott : Duplicate data entered.
8- Click OK
Now try to enter duplicate values and enjoy.
Thanks for your query. Waiting for the next one.
Muhammad Jawad Mirza
Sialkot Pakistan.
I think instead of Conditional Formatting you should use
the Data Validation Approach. This is more closer to your
requirement.
Now follow these steps:
1- Select complete Column A by clicking on the column
letter A. (you may also select a range as per requirement)
2- From Menu click Data > Validation
3- Under Settings Tab. Select Custom from the Allow box.
4- Now type the formula in Formula text box as
=COUNTIF($A:$A,A1)<2
(Optional from 5 to 7)
5- Under Input Message Tab :
Title = Scott's Check Post
Input Message = Avoid Duplication
6- Under Error Alert Tab :
Style = Stop (or Warning or Information)
7- Title = Worng Entry
Error Alert = Scott : Duplicate data entered.
8- Click OK
Now try to enter duplicate values and enjoy.
Thanks for your query. Waiting for the next one.
Muhammad Jawad Mirza
Sialkot Pakistan.