Trying to update cell value based on highlight color of other cell.

Hi,

I am new to excel macros. I want if cell in column C is highlighted green ( RGB 194,214,154) then value of corresponding cell in Column F to same as value of Cell in Column A. My macro is as follows:

Sub CollorFill()
IF Range.("C1:C3000").Interior.Color = RGB(194, 214,154) Then

Range.("F1:F3000").Value = Range.("A1:A3000").Value

End IF

End Sub

But it doesn't work. I tried step in and after reaching If statement , it jumps to End If.

I am not sure what I am doing wrong.

Please help

Please put your code in CODE tags. In the text editor, highlight your code, then press the # key in the toolbar.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Hi Walruseggman,

I tried but it is not working, it is skipping the step Range("F" & Cell.Row).Value = Range("A" & Cell.Row).Value.

I am not sure if it matters or not but the column with green highlight has a conditional formatting. I am attaching my rough excel sheet.

Any help is greatly appreciated.

Hi ARowbot,

thanks for your help. I tried but still not working not sure what I am doing wrong. I have attached my excel. please see the reply below your post.