Viewing 6 posts - 1 through 6 (of 6 total)
• Stupid Excel question
• Dibbs
Member

I have three temperatures T1, T2 & T3. How do I write a formula to highlight if one of the temperatures is more than five degrees different to the others. I know I can just look at the three temperatures and see the difference in an instant, but I’m trying to write a formula to make it idiot proof (because I have been known to work with idiots) 🙄

Cheers

mrmo
Member

use an IF statement,

Something like IF t1>t2+5, do x, IF t2>t1+5…

just think of the combinations and should be good to go. Stoner
Subscriber

use “Conditional Formatting” under “Format”

depending on which one you want to be comparing to the other two (or both?) then assume you have columns A, B and C, in Column A set condition format to be:

“Formula is” (from first drop down box)

=OR(A1<(B1-5), A1>(B1+5), A1<(C1-5), A1>(C1+5))

And set a format (that is different to the natural format) in the “format” button.

that particular formula compares A with B and C for +/-5deg simultaneously. You can obviously change the logical test you want the highlighting to be based upon. jam bo
Subscriber

Is the future nuclear safety of the uk really in the hands of STW?

=IF(AND(MAX(\$J\$7:\$J\$10)>=MIN(\$J\$7:\$J\$10)+5,J7=MAX(\$J\$7:\$J\$10)),”Attention”,””)

Dibbs
Member

Thanks again.

Viewing 6 posts - 1 through 6 (of 6 total)

The topic ‘Stupid Excel question’ is closed to new replies.