hi tom
that's ok
regards

--
hemu


"Tom Ogilvy" wrote:

That doesn't have anything to do with my suggestion. Obviously you have
misinterpreted what I said. If you are going to use code, you wouldn't need
to use data validation at all.

--
Regards,
Tom Ogilvy

"Hemant_india" wrote in message
...
hi tom
see the following code
With rng
For n = 1 To trow - 1
For h = 1 To tcell
rng.Cells(n + 1, h).Select
Debug.Print Cells(n + 1, h).Value
With Selection
If .Validation.Value = False Then
.Interior.ColorIndex = 16
errcount = errcount + 1
Else: .Interior.ColorIndex = 0
End If
using your solution it did not worked
please help
--
hemu


"Tom Ogilvy" wrote:

Data validation doesn't force a user to make an entry - it only
restricts
what can be entered. You are basically asking to format all cells
except
the 3 in question with data validation that will not allow entry unless
one
of the cells in question has an entry. This can be checked with

=counta(A1,A2,B3)0

for example, but still doesn't force an entry - but if applied to all
other
cells would prevent entry until it is met.

--
Regards,
Tom Ogilvy

"Hemant_india" wrote in message
...
hi
i have thre columns of which at least one should contain some text
how do i validate such condition?
thanks

--
hemu