CrimsonPlague29,

1.Select all of your data (in the example provided select from abcd in
"Order" to Closed in "Status"...2 rows X 5 colums)
2.Select Conditional Formatting ([Alt] + O, then D)
3.Change "Cell Value Is" to "Formula Is"
4.Make sure you know which row the active cell is in, it is important for
entering your formula.
5.Enter the following formula:
=$E2="Closed"
(make sure to precede your column with a dollar sign, the column letter
should be the same letter of your "Status" column)
(make sure the row is NOT preceded with a dollar sign, the row number should
be the same number as the active/current cell)
6.Select your desired formatting

HTH,

Conan




"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