Conditional formatting Entire Row Based on single Cell Value

[KKD]

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"

 

[Sheeloo]

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...

 

[Sheeloo]

Sorry mistyped the closing quote

Use
=$D2="Partial"

 

[KKD]

Where do I type this in?
--
KKD

Sorry mistyped the closing quote

Use
=$D2="Partial"

 

[Sheeloo]

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

 

[KKD]

Excellent, thank you!
--
KKD

Where do I type this in?