ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I retrieve a value and its format using the minimum function? (https://www.excelbanter.com/excel-worksheet-functions/53447-can-i-retrieve-value-its-format-using-minimum-function.html)

daled

Can I retrieve a value and its format using the minimum function?
 
I have ten columns of pricing with each column color coded for a specific
vendor. For each row, I want to find the lowest price in those columns. It
would be especially helpful if the price was returned with the associated
color. Is this possible

Barry

Can I retrieve a value and its format using the minimum function?
 
use conditional formatting

"daled" wrote:

I have ten columns of pricing with each column color coded for a specific
vendor. For each row, I want to find the lowest price in those columns. It
would be especially helpful if the price was returned with the associated
color. Is this possible



All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com