Use conditional formatting. Assuming your status column is E, and your rows
are 50 to 70, select your rows, apply a conditional format with the formula
=$E50="closed" applied to the rows with a green fill.

Tyro


"CrimsonPlague29" wrote in
message ...

If the status is change to closed I want to highlight the entire row of
data
Green, as of now only the status column gets formatted green....

Is this possible to do??

Order Req QT Completed QTY Open QTY Status
abcd 10 5 5 Open
defg 20 20 0
Closed

Thanks