|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
drop down list formula
Hi Eric,
take a look at Debra Web
http://www.contextures.com/xlDataVal02.html#TwoWord
"Eric" wrote:
Basically what I'm trying to do is I have cells G18 through G32 that have
drop down values of "Green", "Yellow", and "Red". I have another cell (let's
call it C7) that I want to display one of these colors as a summary cell. For
example if all the G cells are "Green" then C7 is "Green", but if any of the
G cells is either "Yellow" or "Red" then C7 will display as either "Yellow"
or "Red" ("Red" if both are present). Any help with this formula would be
welcome. Thanks.
|