Use cell formatting (e.g. "Good", "Bad", "Neutral") in formulas?
- by ngm
I am compiling a comparison of different pieces of software in an Excel spreadsheet. It is a big long list of features (the rows), with each column being one of the applications I'm evaluating. I've used styles to visually show how well each product meets each feature, as well as the importance of that feature, and now I'm wondering if there's a way I can use those annotations in a formula.
The table is like:
. | Product A | Product B | Product C
Feature A | blah blah blah
Feature B | blah blah blah
Feature C | blah blah blah
.... |
.... |
etc |
Where I've put 'blah' in the table above, in my actual spreadsheet is (potentially lengthy) descriptive text explaining something about this feature in the given product.
I've then used the styles "Good", "Neutral" and "Bad" to visually annotate the description, to show how well each product meets that feature.
For each feature I've also used the styles Accent4, 60% Accent4, 40% Accent4, etc, to annotate the importance of each feature.
Now I'm wondering if somehow I can use those styles (the annotations) to tot up a total score for each product.
e.g., Score for feature A = valueof(60% Accent4) * valueof(Good)
Is it possible at all?
