Stupid Excel question

  • This topic has 5 replies, 5 voices, and was last updated 8 years ago by  Dibbs.
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
    Member

    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.

    Premier Icon 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.