Variables that contain cell formatting

I'm trying to create a case with IF statements that then format the next cell with values stored in a variable. If I add msgbox ClrGreen it returns the values but I can't see how it apply it to the IF statement. I've tried this with functions and subs and am not getting anywhere. My Case and If's work perfectly but the code is getting quite large and I want to reduce it with variables. Any help would be appreciated.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You cannot use variables like that. You cannot put code into a variable, then expect that code to execute if you just put the variable name on a line.

Here is a solution using a Sub. You just included a snippet of your code so it doesn't compile.

Please Login or Register  to view this content.

Note: I omitted passing Cell to the Sub, and just added it. Make sure you use this version.

You have not declared variables. I strongly recommend to everyone that they declare variables. If you declare Cell as Range in your sub then it will compile. I also recommend you declare lRow as Long, Feature As Range,

You're welcome and thanks for the rep! I have marked your thread as SOLVED but in the future you can do it yourself.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."