A function cannot change a cell's color. You would need either condtional
formatting or an Event macro.
--
Gary''s Student - gsnu2007g


"vietvn" wrote:

I'm trying to make a fuction to change cell color when value change,
for example, I call this function is "chcl", when I use
"=if(A15,chcl(A1,red),0)" then if value in A15, color of active cell
change to red else has no change. Please help me to solve this
problem.
Thank you