CODEWITHSUNDEEP
excelmultiple-columnsconditional-formattingline-by-line
Kate
Kate

Reputation: 1

I want to use conditional formatting to highlight a cell in one column if the corresponding line in another column contains a specific value

I am working in Excel Professional Plus 2010. I have searched and the only things I've found are either doing individual line by line highlighting or searching and highlighting an entire column. I have three long columns I am comparing (E & O & P), and I want it to compare and highlight line by the corresponding line. For example, if E38=7, then I want O38 & P38 to be highlighted. I cannot add columns to put in a formula for comparison as it is a standard form. I need it to search for all instances of "7" in Column E and then highlight the corresponding cells in those rows in columns O & P.

image

Upvotes: 0

Views: 1080

Answers (2)

Anna
Anna

Reputation: 1

The Column you want to highlight is where the formatting is applied to:

=$O:$P

Set the rule type to "Use a formula to determine which cells to format" and enter a formula that references the column (with $ to keep it static) and the first row in the array (without $ to allow it to dynamically apply the formatting to each row):

=$E1="a"

Condition

Upvotes: 0

click here
click here

Reputation: 836

Use conditional formatting, set a rule by formula. Something like this: Example Just make the columns/values as you need them.

Upvotes: 1

Related Questions