I have a worksheet that totals data form another sheet. The end user has to copy and paste new rows into this sheet on occasion. I want to do some conditional formatting to be sure the copied row are referencing the correct cells on the "data" sheet.The referenced cells are on the same row. Lets say the Cell references are Sheet1!Z11 and Sheet1!Z25. What I want to achieve is have the Second Cell on my total sheet change color if the cell reference in the second cell is not 14 rows to the right of the first cell reference.