excel - Highlight table row depending on another cell's value -
i have table set of rows , information on several countries. countries in first column of table. highlight table row depending on country selected in sheet.
the table in sheet "rankings" , country selected in sheet "report", on cell b4.
i have tried conditional formatting highlights first cell on table (not entire row) , if country chosen 1 appears first on table.
i guess need formula run through first column of table, detect row in country selected , highlight entire table row.
how able this?
the answer has been hinted @ in comments above. however, i'll spell out
- on sheet
rankings
select rows country names might appear in first column - open new formatting rule dialog selecting conditional formatting/new rule home tab of ribbon
- in "select rule type" (top part of dialog) select "use formula determine cells format" - bottom part of dialog change
- in box labelled "format values formula true:" enter
=$a1=report!$b$4
- click "format" button, choose suitable format , return new formatting rule" dialog , click ok
step 4., assumes first row selected in step 1. row 1. if not case, formula in step 4. should changed reflect correct first row. example if have headers in row 1 of sheet rankings
, first row contains country row 2 change formula =$a2=report!$b$4
.
if use "point , click" method of building formula in step 4., excel uses absolute addresses , create subtly different formula not give results desire.
Comments
Post a Comment