I know how to iterate down the rows, but how do I assign an entire row
font color. To assign red or blue, would it be something like:
if cells(i,1).Value = "Non-Interum Servicing" then
Worksheet.Range.EntireRow.Font.Color = RGB(255, 0, 0)
else
if cells(i,1).Value = "Interum Servicing" then
Worksheet.Range.EntireRow.Font.Color = RGB(0, 0, 255)
end if
end if
Thanks in advance everyone
--
mthoma
-----------------------------------------------------------------------
mthomas's Profile:
http://www.excelforum.com/member.php...fo&userid=2564
View this thread:
http://www.excelforum.com/showthread.php?threadid=39078