Highlight row based on cell value

[Babio1964]

hi,
I was kinda surprised I couldn't find a solution when I Googled this...
Let's say I have columns A through M. In Column C, I have various string values (let's say animals). Now, I want to highlight only those columns A through M when the value in column C is "Dog". I know I can do a For Each - EntireRow.Interior.Color thing, but I always think that looks scrappy when all the columns are highlighted even when they contain no data. For the record, columns A through M is static and will never change (ie There will never be a column N)

I appreciate the help!

 

[Fluff]

Select your data, for instance A2:M100, on the home tab, Conditional Format, New Rule, Use a Formula
=$C2="Dog"
Select the format you want, Ok

 

[Babio1964]

thank you. Sorry, I should have added, I'd like to do this with VBA. Kinda involved, but the data I'm using comes from an outside source and ends up in multiple worksheets...

 

[Fluff]

Ok, how about

Sub Babio()
   Dim UsdRws As Long
   With ActiveSheet
      UsdRws = .Range("C" & Rows.Count).End(xlUp).Row
      .Range("A1:M" & UsdRws).AutoFilter 3, "Dog"
      .AutoFilter.Range.Offset(1).Resize(UsdRws - 1).Interior.Color = 45678
      .AutoFilterMode = False
   End With
End Sub

 

[Babio1964]

Ok, how about

Sub Babio()
   Dim UsdRws As Long
   With ActiveSheet
      UsdRws = .Range("C" & Rows.Count).End(xlUp).Row
      .Range("A1:M" & UsdRws).AutoFilter 3, "Dog"
      .AutoFilter.Range.Offset(1).Resize(UsdRws - 1).Interior.Color = 45678
      .AutoFilterMode = False
   End With
End Sub

Oh my!
You're wonderful. Worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback