Macro to highlight rows based on cell value

[paul_sykes00]

Hi, Hope someone can help with the below,

I have a table of data on sheet 1. Column A is Name.

I am looking for a macro that will highlight the rows with certain names a specific colour.

Thanks in advance, Paul

 

[jolivanes]

Sub Maybe()
Dim c As Range
	For Each c In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
		If c.Value = "Whatever" Then c.Interior.ColorIndex = 45
	Next c
End Sub

 

[paul_sykes00]

Great Thanks, Just one small thing. It currently only highlights the cell in column A, How do I highlight the full row?

 

[jolivanes]

Change this

Then c.Interior.ColorIndex = 45

to this

c.EntireRow.Interior.ColorIndex = 45