On sheet1 (used for data entry) I have a spreadsheet of dimensions. These dimensions are taken as the high and low (i.e. 13.250 in cell A1, 13.245 in cell A2). On sheet2 (used for clearance calculations) I have cell A1 to take the average between cells A1 and A2 from the first page. What I would like to do is conditionally format the cell showing the average to turn red if the difference between A1 and A2 is greater than .003. My spreadsheet is NOT setup in very straightforward columns/rows. There is no merged cells being dealt with, but this is a document going to a customer so appearance and functionality are both important. I will have to do this for about 100 cells and would not prefer to individually format them based on what is found in sheet1. Can I in anyway reference the cells used in the formula to conditionally format? Thanks.