|
|
#1
01-26-2014, 05:00 AM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode