View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vietvn vietvn is offline
external usenet poster
 
Posts: 2
Default Help me to change color (By VBA) of cell if value in the cellchange!!!

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