Automate pulling Conditional formatting

[Kcbundy]

Is there a way to pull data that has Highlight Cell conditional formatting to another worksheet. I can’t post the table because I work with patient info.
For example:
Cell E1 contains data that “needs reviewed” and has highlight cell conditional formatting to change to red. Cell C1 has the patient account record. I want all accounts where in column E contains “needs reviewed” to automatically pull information from the C column to another worksheet

 

[CSmith]

Conditional formatting:

=COUNTIF($E1,"*Needs Reviewed*")

Conditional pull you could do this with a VBA macro.

Sub TransferToNewSheet(Optional SourceSheet As String = "Source Sheet", Optional TargetSheet As String = "Target Sheet")
    Dim CurRow, LastRow As Long
    Dim ss, ts As Worksheet
    Dim wsRow As Range
    Set ss = Sheets(SourceSheet)
    Set ts = Sheets(TargetSheet) ' Target will be overwritten
    LastRow = ss.Cells(Rows.Count, "E").End(xlUp).Row
    CurRow = 1
    For Each wsRow In ss.Range("$1:$" & LastRow).Rows
        If Cells(wsRow.Row, "E").Value = "Needs Reviewed" Then
            wsRow.EntireRow.Copy Destination:=ts.Range("A" & CurRow)
            CurRow = CurRow + 1
        End If
    Next

    ' Cleanup
    Set ts = Nothing
    Set ss = Nothing
End Sub