I consider myself comfortable with Excel, however there is something that i am unsure of how to do and would appreciate your help in finding a solution.
I created a spreadsheet, basically a self evaluation. in my table, i would like one of the columns to contain a drop-down box in each cell, where three options present themselves (ie X, Y Z)
When i selection X the cell turns blue
When i selection Y the cell turns red
When i selection Z the cell turns yellow
I'm then looking to count the number of options selected
eg
x = 2
y = 4
z = 4
as opposed to having three seperate colums in my table, at the moment my three columns = x y z
to count the option i simply put a 1 where appicable, and then count the sum. the solution is the same result, but for data entry purposes its not as clear as could be.
I'm thinking this is involoves some VB,
if you can point me in the right direction, that would be excellent.
thankyou
2006-08-09
11:35:46
·
4 answers
·
asked by
ironfever
2