Highlight Row in Excel

[isjason]

I want to search through a range for the highest number, and then get it to change the font of that row. There may be multiple cells with the highest number so I want to highlight all of those rows.

Can anyone help?

Thanks

- jason

 

[combo]

This works:

[tt]Dim r As Range
Set r = Rows(1)
Set r = Union(r, Rows(3))
r.Select
r.Font.Name = "Wingdings"[/tt]

however, it is not necessary to select range (r.select) to change font.

combo