Hi Hemant
What you can do is,
-select the area in which you want your subordinates to make entries.
-Click the menu Data--Validation
-Select settings then
--under allow select whole number,
--under data select greater than or equal to (you can work with this if you
want to change the conditions)
--select minimum(or maximum- it will change as the case is) type a number
you have set the limit for.
click OK
FIRST TEST AT YOUR END, it should work.
--
vijard
"hdhuri40" wrote:
I have made an excel file in which I am writing cumulative
warranty report for my product. My subordinates are using this file and I
have made it as a shared document.
Now I want to avoid any chance of accidental wrong entry in any cell.
Is there any method whereby I can configure a cell so that it will take
only higher values than the existing entries in the cell.
--
Hemant N. Dhuri
Mumbai
|