I am trying to create a button in excel that allows for an if elseif else statement. ie:if cell(b2:c2) ColorIndex=xlNone then ColorIndex=15 etc.
basically I have three different colors per sheet and 10 sheets. Sheet one has pink grey and none. I have been fighting with this for a while now, I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.