Highlight rows if cells contain specific values

I need help creating a macro to highlight entire rows if a cell in that row (C) contains specific values.

Any ideas?

Thanks in advance

You can use a worksheet event to test the cell and highlight the row.

Do you want all rows that have column C values that meet criteria highlighted or just the active row?

What are the criteria? Example workbook may help.

You would use code something like this

' highlight Red
range("C5").EntireRow.Interior.ColorIndex=3 

' clear higlight
range("C5").EntireRow.Interior.ColorIndex=xlnone