I have a row of 10 cell with 7 different colors and I need to determine the "Color Index" number for each cell in the cell below. A1:A10 have 7 diff colors - B1:B10 refer to the "Color Index" number associated with the cell above.
I would rather not use vba.
I would like to click on a cell and have the number of each click show up in the cell. Example: If I click the cell A5 five times the number "5" appears in the cell. Or click A4 and the number shows up in A5.
Any ideas?
I am looking for a series of Check-boxes that are grouped together. For example, you have two or more options like, Lighting Package 1, Lighting Package 2, Lighting Package 3, etc. If you select Package 1 then change your mind to Package 2 it will uncheck Package 1.