First off, I did search this and came up with nothing so I hope this hasn't been posted b4.
I'm calibrating gauges and making a log of them, and what I need to do is when a gauge is out of tolerance I need it to be highlighted
example say I have an applied pressure in A1, the indicated pressure in B1 and the Difference between the two in C1. I already have the simple formula =B1-A1 in C1... but I need it to automatically highlight in red if the answer is out of tolerance, notated lets say in D1 (+ or - ). so if A was 1 B was 2 making C 1 and the tolerance was .5 i need that answer to highlight.
I'm calibrating gauges and making a log of them, and what I need to do is when a gauge is out of tolerance I need it to be highlighted
example say I have an applied pressure in A1, the indicated pressure in B1 and the Difference between the two in C1. I already have the simple formula =B1-A1 in C1... but I need it to automatically highlight in red if the answer is out of tolerance, notated lets say in D1 (+ or - ). so if A was 1 B was 2 making C 1 and the tolerance was .5 i need that answer to highlight.