Conditional formatting Entire Row Based on single Cell Value

  • Thread starter Thread starter KKD
  • Start date Start date
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"
 
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...
 
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
 
Back
Top