Extract Min and highlight cell from source
Hi, I have a spreadsheet wherein i extract the minimum value per item. The Suppliers are colour coded, and I would like the result to highlight the cell with relevant customer colour code as well. Attached is an example of what I mean. I merely used cell background colour in this instance, but I am sure it requires perhaps conditional formatting. Also have used a straight forward Min function. Hope someone can assist me. Many thanks in advance.
Merle
|