Excel 2007 : Conditional Formatting

[sushil10s]

Hi,

Attached is an excel file with a table and used is the data validation in Columns E, F and H. Kindly provide a way to change the color (e.g, green) of entire row in the table if selected "Approved" from the drop down list (Column E).

[First time user...Please ignore mistake(s) and/or lack of sufficient details (if there are)]

Thanks
Sushil

[arthurbr]

Select range E5:H14 and use

Please Login or Register  to view this content.

as formula for the CF