#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi
is the attached what you need?
__________________
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 |
#3
|
|||
|
|||
hi there. Yes the attached will be my template.
|
#4
|
|||
|
|||
Solved
Hi all I have got this problem solved. It is in fact a macro needed to "getcolor".
Thanks for your input. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
highlight the entire row of current cell | Joanne | Excel | 32 | 05-20-2017 07:30 AM |
Excel 2007, highlight entire row based on data found in one cell | MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
How to highlight the row based on cell value? | Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |
highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |