ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help me to change color (By VBA) of cell if value in the cellchange!!! (https://www.excelbanter.com/excel-programming/407964-help-me-change-color-vba-cell-if-value-cellchange.html)

vietvn

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


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com