Need to highlight the text with Red color for entire row

[vijavad]

Hi Team

I have created drop down list in column " C" and i have Client Reject, Offshore Reject , Onsite Reject and so on other drop down filters...

Now whenever i select the drop down list and if it has a keyword REJECT from the drop down list the entire row text font color to be changed to RED.

 

[JoeMo]

This is sheet code.
To install sheet code:
1. Right-click the worksheet tab you want to apply it to and choose 'View Code'. This will open the VBE window.
2. Copy the code below from your browser window and paste it into the white space in the VBE window.
3. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
4. Make sure you have enabled macros whenever you open the file or the code will not run.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
 If Not Intersect(Target, Range("C:C")) Is Nothing Then
    For Each c In Intersect(Target, Range("C:C"))
        If InStr(UCase(c.Value), "REJECT") > 0 Then
            With Intersect(Rows(c.Row), Me.UsedRange)
                .Font.Color = vbRed
            End With
        Else
            With Intersect(Rows(c.Row), Me.UsedRange)
                .Font.Color = vbBlack
            End With
        End If
    Next c
End If
End Sub

 

[vijavad]

Joe i need in formula to be used in condtional formatting. I am not using macros. Can u pleae suggest

 

[JoeMo]

Joe i need in formula to be used in condtional formatting. I am not using macros. Can u pleae suggest

(1.) Select the entire range you want to apply the CF to.
(2.) Then use this CF formula:

=ISNUMBER(SEARCH("reject",$C1))

change the number in bold red to the row number for the first col C cell in the range you selected in step 1.

 

[vijavad]

Joe thank you very much it worked .