View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Guye Guye is offline
external usenet poster
 
Posts: 19
Default Validation check

hi all
i have created a very long drop list (25 values) for validating all
cells on column E, the same list appears on all the cells on the
columns G,I,K,M... and so forth.
is there a code that can check if in a row 2 or more cells in the
relevant columns contain the same Value.
and in such a case, for exmple change the color of the cells with the
same values.
thanks guy