Pascal’s Triangle

I was pretty excited when I figured out how to use conditional formatting in Excel to make a Sierpinski triangle.  I used very tiny cells, and then used conditional formatting to color in the cells corresponding to odd numbers in Pascal’s triangle.  The video also introduces Pascal’s triangle and explores some number patterns.  Spreadsheet used in the video (Excel 2003).

To do the conditional formatting in later versions of Excel, go to the Styles Group on the Home Tab.  Choose Conditional Formatting, and then choose New Rule.  Choose the last option, “Use a formula to determine which cells to format.”  Then enter the formula as in the video.

Tags: , ,

One Response to “Pascal’s Triangle”

  1. This website was… how do I say it? Relevant!! Finally I’ve found something that helped me.

    Thanks a lot! | bảo hộ lao động, bao
    ho lao dong, bao ho lao dong dong nai, bao ho lao dong dong
    nai, bao ho lao dong tai bien hoa, thiet bi bao ho
    lao dong

Leave a Reply