What's the fastest/easiest way, in a table where I will be adding rows, to highlight the lowest value per row but for every row in the table?
In my table below, I want to highlight the lowest price per item - as in row 2. Do I have to use format painter and copy to each row individually, and remember to do this when I add new rows, too?
I tried changing the range for the conditional format to all the rows for columns B-F, but that highlights the lowest price in the table, not the row.
In my table below, I want to highlight the lowest price per item - as in row 2. Do I have to use format painter and copy to each row individually, and remember to do this when I add new rows, too?
I tried changing the range for the conditional format to all the rows for columns B-F, but that highlights the lowest price in the table, not the row.
| Grocery.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Item | Walmart | Kroger | Aldi | Lidl | Target | Need? | ||
| 2 | Almond Milk | 2.44 | 2.45 | 2.59 | X | ||||
| 3 | Wasa | 3.63 | 4.09 | ||||||
| 4 | Saltines | 1.74 | |||||||
| 5 | Animal *******s | ||||||||
| 6 | Pita chips | ||||||||
| 7 | Progresso soup | 2.38 | 1.49 | ||||||
Sheet1 | |||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| B2:F2 | Cell Value | top 1 bottom values | text | NO |
