Data Validation

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

In each column I want to only be able to enter the same
value in two cells the have excel not allow that to be
typed in anymore. Furthermore can I use Data Validation to
change the two cells with the same value to Bold Type and
a different color.

I am using office xp

Any help would be greatly appreciated

Thank you
 
Let's assume 1 column for now, column A. Select column A
and go to Data > Validation. Choose "Custom" and insert:

=COUNTIF(A:A,A1)<3

HTH
Jason
Atlanta, GA
 
Back
Top