VBA to highlight row with red text

[thelad]

Hi,

I have rows of data and I would like to highlight every row of data that has 0 in column c with red text and Calibri 8.

For every other row that doesn't have 0 in column C it should be blue text and Calibri 8 down to last used row.

Data will start from row 2. Headings in row 1 I dont want touched.

Anyone know how to achieve this? Presume it needs some sort of testing loop?

Regards,

 

[Rick Rothstein]

Give this macro a try...

[table="width: 500"]
[tr]
	[td]Sub MakeZerosRed()
  Application.ReplaceFormat.Clear
  With Range("C2", Cells(Rows.Count, "C").End(xlUp))
    Application.ReplaceFormat.Font.Name = "Calibri"
    Application.ReplaceFormat.Font.Size = 8
    .Replace "*", "", xlWhole, SearchFormat:=False, ReplaceFormat:=True
    Application.ReplaceFormat.Font.Color = vbRed
    .Replace 0, "", xlWhole, SearchFormat:=False, ReplaceFormat:=True
    Application.ReplaceFormat.Clear
  End With
End Sub[/td]
[/tr]
[/table]

 

[thelad]

Hi,

It marked the zero in column C as red but I want to highlight the whole row in red text. Can this be done?

And then for rows that don't have zero in column C I would like blue color text?

 

[thelad]

HI Rick, Any luck with the above? Your solution does put the "0" in red text but I need the entire row in red text