Help me to change color (By VBA) of cell if value in the cell change!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vietvn - 19 Mar 2008 15:09 GMT

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(A1>5,chcl(A1,red),0)" then if value in A1>5, color of active cell
change to red else has no change. Please help me to solve this
problem.
Thank you

Reply to this Message

Gary''s Student - 19 Mar 2008 15:37 GMT

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

Signature

Gary''s Student - gsnu2007g

> 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(A1>5,chcl(A1,red),0)" then if value in A1>5, color of active cell
> change to red else has no change. Please help me to solve this
> problem.
> Thank you

Reply to this Message