View Single Post
 
Old 01-26-2014, 05:00 AM
LeilaniMerle LeilaniMerle is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2014
Posts: 4
LeilaniMerle is on a distinguished road
Default 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
Attached Files
File Type: xlsx Supplier Quotations.xlsx (17.5 KB, 11 views)
Reply With Quote