Conditional Format entire row
 

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

Conditional Format entire row
 

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

Conditional Format entire row
 

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

Conditional Format entire row
 

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