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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using Colored Cells
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using Colored Cells
Hi Carim,
Thanks very much. It worked. "Ananth" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using Colored Cells
Carim - Went to Chip's Site - Noted that he uses
CountByColor = CountByColor - _ ' (Rng.Interior.ColorIndex = WhatColorIndex) to return either a 0 (False) or a 1 (True) Confused with CountByColor MINUS 0 or 1 << Here the True must be coming through as the Traditional TRue = -1 so that 0 Minus -1 = 1 Can you straigthen me out in my confusion? TIA, Jim May "Carim" wrote: Hi, Take at look at Chip's brilliant solution : http://www.cpearson.com/excel/colors.htm HTH Carim |
Reply |
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 |