Creating a formula if cell contains numbers that are +/- another cell
Hi there. I am wanting to create a formula that will highlight a number if the TOL. higher or lower than the number in the +/- cell. I am unable to use a conditional format as there is already a formula in that cell dragging a number from another page.
The other question I have, which should be a simple one, but I never know how to do it is, how do I copy the formula from point A to Z without manually entering it every cell? I also want to do the same thng horizontally across.
I look forward to your answer.
iMac (24-inch, M1, 2021, 2 ports)