VBA to highlight fonts is a row

[saravanan1981]

Hi,

I need help on highlighting entire row

My data range is from Column A to BC


But i need to highlight only text in rows (please note-only font colour not row colour) that are having cell value begins with "Lost" (Column AA) to Red Colour (.Color = -16776961).

I do not want to color up any row before column B and after column AX. Means Colour the fonts only between Column A to AX.

I need to color rows based on the other values on the column AA with Red Colour (.Color = -16776961).

i have attached a sample work book here