Conditional formatting Entire Row Based on single Cell Value
 

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD

Conditional formatting Entire Row Based on single Cell Value
 

Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use
FORUMULA IS with
=$D2="Partial)

You can paste this format on other rows... $D2 in the formula will change to
D3, D4 in other rows...


"KKD" wrote:

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD

Conditional formatting Entire Row Based on single Cell Value
 

Sorry mistyped the closing quote

Use
=$D2="Partial"

"Sheeloo" wrote:
Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use
FORUMULA IS with
=$D2="Partial)

You can paste this format on other rows... $D2 in the formula will change to
D3, D4 in other rows...


"KKD" wrote:

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD

Conditional formatting Entire Row Based on single Cell Value
 

Where do I type this in?
--
KKD


"Sheeloo" wrote:

Sorry mistyped the closing quote

Use
=$D2="Partial"

"Sheeloo" wrote:
Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use
FORUMULA IS with
=$D2="Partial)

You can paste this format on other rows... $D2 in the formula will change to
D3, D4 in other rows...


"KKD" wrote:

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD

Conditional formatting Entire Row Based on single Cell Value
 

In the FORMULA IS formula under Conditional Formatting...after selecting the
cells to highlight with row2 (or cells in row 2) as the first row in the
selection

Like you were doing
highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

"KKD" wrote:

Where do I type this in?
--
KKD


"Sheeloo" wrote:

Sorry mistyped the closing quote

Use
=$D2="Partial"

"Sheeloo" wrote:
Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use
FORUMULA IS with
=$D2="Partial)

You can paste this format on other rows... $D2 in the formula will change to
D3, D4 in other rows...


"KKD" wrote:

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD

Conditional formatting Entire Row Based on single Cell Value
 

Excellent, thank you!
--
KKD


"KKD" wrote:

Where do I type this in?
--
KKD


"Sheeloo" wrote:

Sorry mistyped the closing quote

Use
=$D2="Partial"

"Sheeloo" wrote:
Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use
FORUMULA IS with
=$D2="Partial)

You can paste this format on other rows... $D2 in the formula will change to
D3, D4 in other rows...


"KKD" wrote:

How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell
to highlight.

My data is simple:
PO# Inv# Amt Status
ABC 123 50.25 Partial

When the status reads "Partial" I want the entire row to be highlighted, not
just the cell that reads "Partial"
--
KKD