View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ananth Ananth is offline
external usenet poster
 
Posts: 51
Default 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