I loved this tutorial and used it with a Y7 class in England. They loved the patterns and it finished off our work on sequences really well. The only problem is that excel will only allow 3 conditional formats so we got stuck at mod 3. Do you know a way around this?
As far as I know, you only get three colors. It can be hard to see patterns with too many colors, though. If you use two colors with higher mods, "is equal to" 0 (light) and "is not equal to" 0 (dark), you can see patterns clearly, especially if you make the cells even smaller and use more rows.... or try variations.
In my Sieve of Eratosthenes II video I show how to use AND and OR to assign multiple values to each color.
You're very welcome. Glad it helped
dborkovitz 2 years ago
thx a lot! It really helped me :)
Shaitan2323 2 years ago
thank you! i'm an IB student in germany, and this video was brilliant for me
Gniruks 2 years ago
Glad you liked it, thanks for commenting.
dborkovitz 2 years ago
I loved this tutorial and used it with a Y7 class in England. They loved the patterns and it finished off our work on sequences really well. The only problem is that excel will only allow 3 conditional formats so we got stuck at mod 3. Do you know a way around this?
technicolour1 3 years ago
Glad the video worked well with your class!
As far as I know, you only get three colors. It can be hard to see patterns with too many colors, though. If you use two colors with higher mods, "is equal to" 0 (light) and "is not equal to" 0 (dark), you can see patterns clearly, especially if you make the cells even smaller and use more rows.... or try variations.
In my Sieve of Eratosthenes II video I show how to use AND and OR to assign multiple values to each color.
Good luck!
dborkovitz 3 years ago
Thanks for my first comment! Glad you liked it, let me know how it goes.
dborkovitz 3 years ago