[RESOLVED] Changes in Whole Sheet....

[spud]

To change a cell to red when certain text is inserted I have used this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("A1").Text = "RTU" Then
Range("A1").Interior.Color = RGB(255, 0, 0)
End If

End Sub

what I would like to do is If any Cell in the worksheet has this value it changes to Red?

thx

[DKenny]

Spud
Why don't you use conditional formatting to achieve this? That would be a much easier way.

[spud]

Haven't realy used Exel can you give me an example?

[Static]

ok.. in the sheet.. click the top corner box (left of A and above 1)
the WHOLE sheet will be selected

then in the menus
select FORMAT > Conditional Formatting

Condition1
Cell Value Is - [Change to "Equal to" in the second combo] - and enter RTU in the third box
clikc the format button
select the Pattern tab
select RED
click OK
click OK

[spud]

Thx Static, DKenny you lern somthing new everyday