Hello and thanks in advance for helping me out!


I have a set of 4 columns ( C to F) . I want the cell in C1 to be highlighted in a specific color (say red) if its value is LOWER THAN ALL the other values in D1 to F1). On the other hand, I want the cell in C1 to be highlighted another color (say green) if its value is HIGHER THAN ALL the other cell values in D1 to F1.

I've tried different methods but have been unable to accomplish this.

Thanks !

D. Berliner