Jan 08 2020 05:04 PM
So I hit a road block on a large spreadsheet (300+ mb) that I've been working on.
I've used conditional formatting to color code cells in 15-20 columns. I want to create a formula that will generate a score for that row, based on values that I assign to different colors. Some of the scores for the same color would vary based on the column. For example, a blue cell might be worth 5 in column M but 3 in column BC.
Here's an example of my scoring (using random columns and scores for illustrative purposes):
I would then have a cell at the beginning of the row that would tally up those scores and would be color-coded itself, using conditional formatting.
Can anyone help point me in the right direction?
Thanks.
Jan 08 2020 08:12 PM
Jan 10 2020 07:05 AM
Jan 10 2020 07:28 AM
I think you may have missed the second part of my question/observation:
I had written "one has to ask (at least I have to ask) what are the values in those cells, values that create the conditions that generate the various colors, and what creates THOSE values?"
The most helpful thing you could do at this point is actually upload your spreadsheet, or a sampling of it. Otherwise, anybody out here is kind of working in the dark. Your description gives at best a cloudy idea of what you're working with--words alone have their limitation. And an image of what you're working with--despite the cliche about an image being worth a thousand words--an image alone wouldn't be much better. We need to see the underlying reality.
Jan 10 2020 09:37 AM
My apologies for misreading that and not answering the question. Some of the CF is based on numerical values, others are IF formulas based on cell text/content, and some are a combination of those.
Attached is a very tiny selection from one of the worksheets with over half the columns removed.