Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help me to change color (By VBA) of cell if value in the cell chan
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me to change color (By VBA) of cell if value in the cellchange!!! | Excel Programming | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |