|
-
Jun 7th, 2006, 08:24 AM
#1
Thread Starter
Fanatic Member
 [RESOLVED] Changes in Whole Sheet....
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 
Last edited by spud; Jun 7th, 2006 at 08:30 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote