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):Column A would be excluded completely
Blue cells (except column M) = 3
Blue cells in column M = 6
Green cells (except column M) = 4
Green cells in column M = 10
Yellow cells (except column M) = 2
Yellow cells in column M = 4
Orange cells (except column M) = 1
Orange cells in column M = 2
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.
Bookmarks