View original (French)

Conditional formatting: Highest and lowest value by row

Solved
Justine -  
PapyLuc51 Posted messages 4566 Registration date   Status Membre 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 réponses

Réponse 1 / 4
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 508
 
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
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 508 > Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention  
 
Greetings

Indeed, a typo in my typing

Best regards
0