...which won't work if the color is the result of Condition Formatting (in such a case, the OP would need to have his code perform the same relational test that the Conditional Formatting is using and take action if that relational test return True).try to take a look at interior.color
You raise a good point and you are probably right... I just posted what I did because I have a "feeling" about what I think the OP did, that's all).Why would he make the cell color green to change the cell value into a number later. If that would be the case, the logical thing would be an if function based on a value immediately.
You raise a good point and you are probably right... I just posted what I did because I have a "feeling" about what I think the OP did, that's all).
You raise a good point and you are probably right... I just posted what I did because I have a "feeling" about what I think the OP did, that's all).
This is my current code, but it doesn't produce results.
Code:If ActiveCell.Interior.color = RGB(174, 240, 194) Then ActiveCell.Value = "0"