Modify Code to change cell background color

Hello, I have the code below set to change the background color based on certain conditions. What I need to do is change it so that if none of the conditions are met, it does not change the color at all. As it is written now, if anything is entered in a cell that has a background already set, but does not meet these conditions, the cell turns white.

Please Login or Register  to view this content.

Thanks!
Clayton Grove

Hi Clayton, try this code:

Please Login or Register  to view this content.

I think if you change your code to this it will work the way you need it. Unfortunately, Case statements don't have a Like or wildcard operator so you have to force it to perform other tests (which doesn't make it much more efficient than an If/ElseIf/Else/EndIf statement).

Please Login or Register  to view this content.