View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JStiehl JStiehl is offline
external usenet poster
 
Posts: 35
Default Multiple Data Validation

I have six columns titled B, M, L, A, S, E. I have a data validation that
prohibits X's from being entered under more than 3 of the 6 columns per row.
I need another data validation that prohibits users from entering their 3 X's
under the columns B, L, and S together (all other combinations are fine).
Any help is much appreciated.