hello max,
hi kaci, i guess you're also an expert cause you share your files to other
users..
Did you try ToolsTrack Changes
Online Help files will give you the control to even accept or reject changes
made by other users...
I guess this is the reason why you like to validate changes.
the color conditional format with Max suggestion is the best way.
happy holidays.

"kaci" wrote:

Hello,

Thank you. However, all my cells are already filled with information, ie.
all cells are non blank. So it does not work.

What else can I do? All my cells are non blank, but I would like to know
which cells have been changed by users.

Thanks

"Max" wrote:

Perhaps you mean this kind of play using conditional formatting ..

Assume inputs will be made in A1 down

Select col A (click on the col header "A")
Click Format Conditional Formatting
Under condition 1, make it as:
Formula is: =A1<""
Click Format button Red fill n white font/bolded? OK
Click OK at the main dialog

Test it out .. When inputs are made in col A, the cells will be formatted:
Red fill n white font/bolded. When you clear the cells (ie press Delete),
it'll turn back to "white"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kaci" wrote:
Hello all experts,

I have a worksheet which contains the data, and I would like to set up a
data validation function that whenever a user updates a cell, the cell will
change the color from white to red.

How can i do it? Please help.

Thanks million.