Fwd: $$Excel-Macros$$ Help required in conditional formatting

Adding in the same mail in bold letters Hi Dilip, Thanks for your efforts but please tell me how it works as I want whenever the entire column* D* will have the value *(In process or in progress)* than color of specified row (e.g.cell A2 to I2) should change as per the specified color(e.g

Fwd: $$Excel-Macros$$ Help required in conditional formatting

Hi Dilip, Thanks for your efforts but please tell me how it works as I want whenever the entire column* D* will have the value *(In process or in progress)* than color of specified row (e.g.cell A2 to I2) should change as per the specified color(e.g. Yellow or Red). *Unfeigned Regards Manoj S Ne