Sample files: Using conditional formatting to highlight a cell in the same row as the active cell
These files demonstrate the technique described in the article How to use conditional formatting to highlight a specific cell in the same row as the active cell.