I have a column of cells that range from 0-1 that have a 3 color gradient scale for the background. 0 is green, 0.5 is
yellow, and 1 is red. I also have shapes elsewhere on the sheet that correspond to each cell in the column.
would like to have the shape fill color match that of its corresponding conditionally formatted cell.
can get the shape fill color to match that of the cell fill color (not the conditional format color) by using the following
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
Set c = ActiveSheet.Range("SectionC3")
If Intersect(Target, Range("SectionC3")) Is Nothing Then Exit Sub
Selection.ShapeRange.Fill.ForeColor.RGB = c.Interior.Color
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
If there was something to replace "c.Interior.Color" with that referred to the conditional format, I think it would
I am using Excel 2010.
Any help would be greatly appreciated. Thanks!