The first thing is to make sure the conditional formating in the status
column has a $ in front of the column. For example

=if($E5="Closed")

The copy the status column and select the other columns. Next Past Special
and select format only from the Past Special menu.

"CrimsonPlague29" wrote:


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