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'.
Re: Highlighting Cells if Specific Data Appears in Adjacent Cells
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.
Bookmarks