Hi,
I want to change the background color of my row according to cell value. For this i have to loop through whole sheet mean say i want to loop through all cell in A say from $A1 to A1000 and where i found word "Absent" row should be red or something like this.

How can i achieve this in Excel.
Thanks in Advance