1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • [2010] conditional formatting not working

    From Ammammata@21:1/5 to All on Thu Feb 6 09:06:26 2020
    Il giorno Thu 06 Feb 2020 10:03:32a, *Ammammata* ha inviato su microsoft.public.excel il messaggio news:XnsAB5B6653C8E70ammammatatiscalineti@148.251.67.112. Vediamo cosa ha scritto:

    https://i.imgur.com/0sCxJB2.png

    note: quantities are INTEGERS, there are no hidden decimals

    rows 132 and 133 contain the same data, but format is different

    row 136 should be highlighted since the sum is wrong, but it's not

    please help, thank you


    addendum: I corrected the error in the formula, there was a minus instead
    of a plus, but didn't solve :/

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Thu Feb 6 09:03:32 2020
    https://i.imgur.com/0sCxJB2.png

    note: quantities are INTEGERS, there are no hidden decimals

    rows 132 and 133 contain the same data, but format is different

    row 136 should be highlighted since the sum is wrong, but it's not

    please help, thank you

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)