| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If Sheet1.Cells(Target.row, 1).Value = "Failed" Then
Sheet1.Cells(Target.row + 1, 1).Select
End If
End If
End Sub
------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I condition format block of cells ? | Excel Discussion (Misc queries) | |||
| Is there a way to color a cell if it meets specific condition | Excel Discussion (Misc queries) | |||
| How to Add columns if a condition exists | Excel Discussion (Misc queries) | |||
| Repeat cell data for specific condition | Excel Discussion (Misc queries) | |||
| How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) | |||
Threaded Mode
