[Solved] Conditional Formatting : Action if value in two cel

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hey all,
    trying to do a "double-check" method and want to check to cells with eachother that always should be 0 (zero) and if anything else (- or +) I want XL to notify.

    First had an idea of a watermark appering but maybe that one is to complex without vba so then I tried with conditional formatting.

    Saw a formula with ABS that I tried but it didn´t work out.

    Anyone with ideas?
    =R72-S72 shall equal 0 in T72
    "=IF(T72 is other than 0, then mark text"

    or is it better thinking:
    "=IF(R72 and S72 isn´t the same, then mark text"?

    All the best

  • Let me know if i get it right.

    You want to Conditionally format a cell if another 2 cells are not equal.

    If that is the case, you can write in Conditional Formatting for T72
    and give desired formatting.

    This will mean, if R72 is not equal to S72, the conditional formatting will work.

    Thanks: ~Yogendra

  • Andy,

    Once we write "=R72<>S72" it automatically results "TRUE" and "FALSE" based on the values of the two cells, so no need for if condition.

    Thought just might help :)

    Thanks: ~Yogendra

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!