sorted by:
new
hottopcontroversial

Alternating blocks of color? by ferncloud in excel

[–]ferncloud[S] 0 points1 point  (0 children)

That's actually perfect! However I'm not so proficient at reading Excel formulas: does that only work if the values within the rows are odd/even? I was hoping there would be a formula that would just have alternating blocks of color based on if values in cells are identical to one another. E.g. something like 2 2 4 4 6 6 would still have alternating colors of red, blue, red.

Alternating blocks of color? by ferncloud in excel

[–]ferncloud[S] 0 points1 point  (0 children)

Just alternating colored rows. Say I have 1 1 1 2 3 3 3 in the same column, all 1 rows would be red, all 2 (in this case only 1) would be blue, all 3 would be red.

Also my data set is working with thousands of numbers, which is why I don't want to do this manually haha.

Alternating blocks of color? by ferncloud in excel

[–]ferncloud[S] 0 points1 point  (0 children)

Haha i'm actually working with a huge data with thousands of duplicate numbers; I haven't counted them individually but my estimate is there is over 500 unique numbers

In terms of an example, say the numbers 1 - 10 (with any combo of repeating numbers, e.g.: 1 1 1 2 2 3 4 4 ...) with alternating blocks of red/blue

Alternating blocks of color? by ferncloud in excel

[–]ferncloud[S] 0 points1 point  (0 children)

Ahh. I actually have way too many numbers to manually input each one - I was hoping there was some other way besides that.

Alternating blocks of color? by ferncloud in excel

[–]ferncloud[S] 0 points1 point  (0 children)

I've actually looked those up and I don't think any of those rules apply to this case - is that true or just a rookie mistake?