And if your intent is to prevent duplicate data entry ..

Select A1:F2 (ensure A1 is active cell, as before)
Click DataValidation
In the settings tab:
Allow: Custom
Formula: =COUNTIF($A$1:$F$2,A1)1
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tikchye_oldLearner57" wrote:
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