I'm attempting to design a command that will:
Examine all cells within a given range in my sheet
If the value of that cell equals what I want:
offset one cell down
color the offset cell with an RGB of my choosing
The terms that it's going to search are column headings so in order to color my graphs as desired I need to fill the first cell under the column heading. As many of you may know, graphs won't take their color from cells that are conditionally formatted...
At any rate, my code below just highlights seemingly random cells. It's odd, really. It seems really simple. If anyone has any ideas as to what I'm missing I could really use a 2nd set of eyes here.
<code>
Sub Find_n_Highlight()
Application.ScreenUpdating = False
' begin for/next loop
For Each ce In Range("B3:Y400")
' if the cell's value is management then move down one cell and color that cell turd orange
If ce.Value = "Management" Then
ActiveCell.Offset(1, 0).Activate
ActiveCell.Interior.Color = RGB(238, 175, 48)
End If
Next ce
Application.ScreenUpdating = True
End Sub
</code>
Thanks all!