If Then function question

[AntG]

I need a function or formula that will allow me to track if data in a
specific cell has been changed. I am in charge of cell phones here in the
office and need to easily be able to see if an employees total amount due for
cell phone usage has changed since the last pay period. Either by displaying
in a cell "Change" or by highlighting the cell.

 

[Bob Phillips]

Is this what you mean?


=IF(A1<>B1, "Change,"")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Anthony]

Yes, but if the contents of, lets say A1 change the next time I input data
into the sheet I want to display "Change" or " " in, lets say A3.