Interior color question

[Cowichandave]

Want to show only the value only if equal to F8 else it should be blank until another cell has the same value as F8
Without the if statement it works but shows value of each cell in the range
With the if statement it is blank or whatever value I choose
What am I missing?


Range("F8:F2000").Select
For Each c In Selection
c.Offset(0, -4).Value = c.Interior.Color

If c.Offset(0, -4).Value <> Range("F8").Value Then c.Offset(0, -4).Value = ""
Next c

 

[Peter_SSs]

That is absolutely awesome. Thanks I will mark this as solved

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.