View Single Post
  #2   Report Post  
vijay
 
Posts: n/a
Default

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