Hi,
I have a list in column H, from H5 to H999. I have the same list on another tab in column D. If the user changes anything in H5:H999, I want the cell to turn red. How can I conditionally format this so H5 looks at D5 from the second tab, H6 looks at D6, H7 looks at D7, and so on. All of...