Copy Cell Color to Another Cell Using If Statement

[Foxmann250]

Hey Guys,

I'm not too savvy when it comes to VBA so I need a bit of assistance. I'm trying to make cell C1's color match cell C3's color when I input "1" into cell L1. Then I'd like to alter this code so that if I input "2" into cell L1, C1's color will match cell C4's color, and so on. I'd like this macro to run anytime cell L1 changes.

Thanks for the help in advance.

Josh

 

[All2Cheesy]

I'd suggest using conditional formatting over VBA for this.
Home-->Conditional Formatting-->New rule

I'd say the 'use a formula to determine which cells to format option' is What you'd need.

 

[Foxmann250]

Hey thanks for the reply. Let me try to explain better what I'm trying to do and why conditional formatting doesn't work for me.

Cell C3 has color scale conditional formatting, so that cell will change shades of colors depending on its value. It's value will change daily as will its color. I then want cell C1 to change its color to match what C3's color is since cell C1 will have a constant value and never change. That way cell C1's color changes but the value is always the same. From my understanding there is no conditional formatting rule that can do this.

THEN... I have a graph. This graph is linked to C1 (as well as some other cells) and I would like the colors of my graph to match the color of cell C1. That way, as C3 changes, C1 will also change, as will the graphs color. It's kinda hard to explain so if you need me to post some pics or the doc itself I can. This is all an attempt to use a donut and pie chart to create a heat map of a circle.

 

[Foxmann250]

Here's what I'm working on:

The values in C2:H2 are constants that the Donut graph is referencing. I2 is what the pie graph is referencing. These cells can't change value or the graphs would not be sectioned the way I need them to be. If I can have each section of the donut/pie graphs change color to the cells they are referencing (C2:I2) then all I would need is to have those cells change color to what I want. My end goal is to be able to input the # I want in L2 and have C2:I2 change color to C4:I4, C5:I5, etc. Hope that helps.

 

[All2Cheesy]

Hmm... That goes a tad beyond my level of excel knowledge. Sorry I can't be of anymore help.

 

[Foxmann250]

No worries mate, hopefully someone else can assist me with their VBA skills.