View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tikchye_oldLearner57 tikchye_oldLearner57 is offline
external usenet poster
 
Posts: 77
Default check for repeated data

hi community

is there a way to do checking for repeated data entry in a range of cells,

A B C D E F

1 10 5 6 11 3 9

2 5 13 2 11 1 0

as an example above, i want to check for repeated data in the cell range and
have it highlighted if more than 1 cell are detected

any help would be much appreciated

thanks community
--
oldLearner57