Running if statement through VBA on single cell values dependent on selection

So I am attempting to find a way to work this issue and have not really found any leads on how to go about doing this.

Basically I have created a button that will change the color and value of cells that are selected. I would like to find a way to create an if statement that will not change the color or value of certain cells in the selected area.

The problem I have run across is my code works for a single cell selection, but the moment I select more than one cell the if statement allows all of the cells to change. I am unsure how I need to go about properly creating this if statement

Please Login or Register  to view this content.

I've attempted Where statements as well but i feel like I'm not completely understanding how to run the if statement in each cell of the selection.

You declared a "Cell" variable, started a LOOP using that cell variable to check each cell of the current selection individually, but then you failed to use the "cell" variable for your color commands:

Please Login or Register  to view this content.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.