Conditional Formatting in Multiple Columns

[dbuzo]

Good morning,
I want to highlight an entire row if specific text is entered in a cell. For example, each row has data for employees. Column B has the role of the employee (primary, secondary, supervisor). If "primary" is in column B then I want the entire row highlighted (or at least their name) to be formatted as well. Is this possible?

 

[ChrisBM]

'Put in start and end rows for 1 and 100
For i = 1 to 100
       If Range("B" & i).Value = "primary" Then
             Rows(i & ":" & i).Select
                            'Highlight row
                            With Selection.Interior                   
                                             .Pattern = xlSolid
                                             .PatternColorIndex = xlAutomatic
                                             .ThemeColor = xlThemeColorDark2
                                             .TintAndShade = -0.249977111117893
                                             .PatternTintAndShade = 0
                         End With
        End If
Next

 

[Special-K99]

Select B1

Conditional Formatting
New Rule
Use a formula to determine...

=($B1="primary")

format as required
Use Format painter (paintbrush icon) to copy to other cells

 

[dbuzo]

Nailed it Special-K99 -- thanks!