+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting or ...??

  1. #1
    Brian Clarke
    Guest

    Conditional formatting or ...??

    I have a simple worksheet of jobs I need to do. Just 3 columns, and when I
    put a date in column 3 I would like the row to be hidden immediately
    (because the job is finished).

    Any suggestions would be appreciated.




  2. #2
    Carim
    Guest

    Re: Conditional formatting or ...??

    Hi Brian,

    You could adapt something along these lines :

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Cell As Range
    Set Target = Range("C2:C20")
    If Target Is Nothing Then
    Exit Sub
    Else
    For Each Cell In Target
    If Cell.Value <> "" Then
    Cell.Offset(0, 0).EntireRow.Hidden = True
    End If
    Next Cell
    End If
    End Sub

    HTH
    Cheers
    Carim


  3. #3
    GS
    Guest

    RE: Conditional formatting or ...??

    Hi Brian,

    Something like this should do what you want:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 Then
    If IsDate(Target.Value) Then Target.EntireRow.Hidden = True
    End If
    End Sub

    Regards,
    GS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1