google-sheetsgoogle-sheets-formulaconditional-formatting

conditional formatting to highlight the highest value in a row compared to all the columns before it

I am trying to figure out the conditional formatting formula to apply to a range of a row and have it highlight the value in the current cell if it is higher then all the values in the same row but only the values to the left of the current cell.

This is a weekly tracker of a score and I want it to highlight green if it is a new weekly high score.

So it looks like this.

enter image description here

I have tried to do something like this =B1>MAX(A1:COLUMN()-1)

Solution

  • Assuming you have the numbers in A1:F, you can simply use the following formula applied to the range B1:F:

    =B1>MAX($A1:A1)