Forum Discussion

Maurice Hemingway's avatar
Maurice Hemingway
Copper Contributor
Jul 04, 2018

Replicating Conditional Formatting

In a spreadheet, I have conditional formatting so that in a row, the lowest value is formatted with a red font colour.  I can apply this row by row either from scratch or using "Format Painter" but this needs to be undertaken a row at a time.

Please can someone tell me if there is there a way of quickly applying this row conditional formatting across the spreadsheet so that the lowest value in each individual row is highlighted?  I'm sure there must be an easy way but haven't yet found it.

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Maurice,

     

    You may apply the rule with the formula

    =B2=MIN($B2:$M2)

    to your entire range with some gap

Resources