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.