Forum Discussion
Solved
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 t...
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
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