Forum Discussion
Maurice Hemingway
Jul 04, 2018Copper Contributor
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
- SergeiBaklanDiamond Contributor
Hi Maurice,
You may apply the rule with the formula
=B2=MIN($B2:$M2)
to your entire range with some gap