View original (French)

Compare 3 columns of numbers

Solved
IsaMuse Posted messages 4 Status Member -  
IsaMuse Posted messages 4 Status Member -
Hello,

I would like to compare 3 columns of numbers (using Numbers) and highlight the cell with the highest number in color. How can I do that, please?
Thank you very much

Configuration: Macintosh / Safari 11.1.2

2 answers

  1. Anonymous user
     
    Hello,

    it is possible with a trick to create a cell that contains the maximum value of the columns, and create a conditional format based on this cell. But do not forget that several cells can contain the same value. Example:





    Best regards.

    0
    1. IsaMuse Posted messages 4 Status Member
       
      Good evening,

      Ouch, actually, the comparison needs to be made for each line (between groups of 3 columns). So I don't have a maximum value.
      Thank you
      0