Conditional formatting Entire Row Based on single Cell Value

K

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"
 
S

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

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
 
Top