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)

Posted on Sep 27, 2022 2:00 PM

Reply
18 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating a formula if cell contains numbers that are +/- another cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.