Tagged ‘Pascal’s triangle’

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.