View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ben w[_2_] ben w[_2_] is offline
external usenet poster
 
Posts: 4
Default cell with static current time

cell has list validation

"Gary''s Student" wrote:

Does the cell change because of manual entry or does it have a formula in it?
--
Gary''s Student - gsnu200743


"ben w" wrote:

i would like a cells in a column to display the curent static time the cell
in the previous column is a certain value
ex:
if cell value is "out" or not "in" then next cell to display when value
changed.
any answers? macros, formulas, setting changes?