Highlighting in Excel
Not sure if this is what you want but here's a little macro:
Sub MyHighlight()
If Range("B1").Value "" Then
Range("A1").Interior.ColorIndex = 6
ElseIf Range("B1").Value = "" Then
Range("A1").Interior.ColorIndex = xlNone
End If
End Sub
HHarold wrote:
How do I highlight(change fill color) in one cell when text is entered in
another cell and not change the value of the cell I want highlighted?
|