Data Validation

[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

 

[Jason Morin]

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