I've searched for examples and tried many different things, but it's just not working. This is a personal project I'm working on and would love some help to get it solved and running.
I've made a list and I want to go through a column (with an UNKNOWN set Range, items may be added or removed), and if the cell value says "Yes" I want it colored Green. If it says "No" I want it colored Red.
Here is what I have so far...
Option Explicit Sub ChangeColor() Dim cell As Range Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If Range("C2").End(xlDown).Offset(2, 0).Value = "Yes" Then cell.Interior.Color = RGB(0, 255, 0) Else cell.Interior.Color = RGB(255, 0, 0) End If Next End Sub
Any help is greatly appreciated!