View original (French)

Conditional formatting: Highest and lowest value by row

Solved
Justine -  
PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   -
Hello,

I'm reaching out to the community for help with a problem I can't seem to solve.
I want to format (red or green background) the highest and lowest value on each row of my table (which contains 4 columns and over a hundred rows).

Is there a formula or trick to highlight these values by row?

Thank you,

4 answers

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    Hello

    For data in columns A,B,C,D starting in row 1

    select A1:D100 and open the conditional formatting / choose the last "Use a formula..."

    For green (lowest value) use this formula
    =A1=MIN($A$1:$D$1) and choose green fill format

    Click on new formula

    For red (highest value) use this formula
    =A1=MAX($A$1:$D$1) and choose red fill format

    Best regards
    1
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello (everyone)
      papyluc, just a small correction to make it work line by line:
      =A1=MIN($A1:D1)
      so no $ in front of the 1
      thanks
      2
    2. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511 > Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention  
       
      Greetings

      Indeed, a typo in my typing

      Best regards
      0