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

Supplier Quotations.xlsx (17.5 KB, 11 views)

Hi
is the attached what you need?

Attached Files

Quotation.xlsx (14.6 KB, 12 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

hi there. Yes the attached will be my template.

Hi all I have got this problem solved. It is in fact a macro needed to "getcolor".

Thanks for your input.