Highlighting Cells if Specific Data Appears in Adjacent Cells

Hello,

I have a couple of spreadsheets that has several columns each containing several hundred thousand rows of codes. To quickly analyze this data, I am trying to come up with a conditional formatting formula to highlight the respective cells when specific values occur next to each other. A particular code will show up in many cells, but the code that is the respective adjacent cell is always different. I need to know when row A contains, for example, '9928559' and row B contains '36415RT'.

Thank you for any help!

Use this formula in the conditional formatting dialogue box:

=AND($A2="9928559",$B2="36415RT")

assuming the cell you want to highlight will be on row 2 - use the Format Painter to apply the same CF to other cells.

It is not clear if '9928559' is meant to be a number or a text value - I assumed a text value as these are codes, but if it is a numeric value then omit the apostrophes from that part of the formula.

Hope this helps.

Pete

Thanks Pete, that works!

That's good to hear - thanks for feeding back (and for the rep).

Pete