jsgarner19
New Member
- Joined
- Apr 19, 2012
- Messages
- 6
Hello all,
I have searched hoping to not have to bother anyone with this question, but haven't found one that quite matched up with my needs.
I am looking for a way to highlight a single cell of 3 columns (columns E, I and M), and 300 rows (starting with row 2)that is the lowest number in each row.
For instance Conditional formatting works wonderfully when I highlight cells E2, I2, and M2 choose Conditional Formatting>top/bottom rules> bottom 10 items > change to bottom 1, then OK.
It works perfectly, except, I don't want to have to ctl click e3,i3,m3 then follow the steps above for each and every row for 300 rows.
So, in summary, every row needs to highlight the lowest number, down the entire sheet.
This is for comparisons between pricing of 3 different food vendors, so that we can choose from month to month the lowest pricing. Not sure if this is going to end up being more work inputting the values each month, but if that is the route we should choose, I want to be able to, at a glance, see the cheapest vendor for a given food product.
Any help would be appreciated.
Thanks
Jim
I have searched hoping to not have to bother anyone with this question, but haven't found one that quite matched up with my needs.
I am looking for a way to highlight a single cell of 3 columns (columns E, I and M), and 300 rows (starting with row 2)that is the lowest number in each row.
For instance Conditional formatting works wonderfully when I highlight cells E2, I2, and M2 choose Conditional Formatting>top/bottom rules> bottom 10 items > change to bottom 1, then OK.
It works perfectly, except, I don't want to have to ctl click e3,i3,m3 then follow the steps above for each and every row for 300 rows.
So, in summary, every row needs to highlight the lowest number, down the entire sheet.
This is for comparisons between pricing of 3 different food vendors, so that we can choose from month to month the lowest pricing. Not sure if this is going to end up being more work inputting the values each month, but if that is the route we should choose, I want to be able to, at a glance, see the cheapest vendor for a given food product.
Any help would be appreciated.
Thanks
Jim
Last edited: