thanks a whole lot! u solved the hassle of needing to check through my
employees' work thoroughly!
"Max" wrote:
Oops, you did say col D
It should read:
Select col D
Click Data Validation
Under Allow, choose Custom
Put in "Formula:" box: =D1<10
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---