Forum Discussion
Conditional formatting g for all rows
I am trying to highlight lowest price on each row for the entire sheet.
here is my data table
Is there a way to apply the conditional format to the whole sheet so each row highlights the lowest price.
thank you
1 Reply
This rule for conditional formatting works in my sample sheet.
=A2=MIN($A2:$H2)This is the applies to range for conditional formatting.
=$A$2:$H$20
