| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using Colored Cells
I am working for a Car dealer who handles 20 type of cars in each segment.
For comparing features of each car in a segment, I shade the cell with Rose color to indicate that the car has that attribute., while blank indicates the non-availability. I HAVE developed a configuration sheet for each car. Car Types are in Column headers & configuration description in the rows I am creating a summary sheet for all cars in a segment. In the summary sheet I would want mention the attributes by looking at the configuration sheet those cells , colored in Rose as Yes and Blank as No Any help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Two Reference Cells in VLOOKUP, Probably easy but .... | Excel Discussion (Misc queries) | |||
| vlookup on large text in cells | Excel Worksheet Functions | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
| Count or sum colored cells | Excel Worksheet Functions | |||
Threaded Mode
