png, 692.49 KB
png, 692.49 KB
xlsx, 91.59 KB
xlsx, 91.59 KB

This is a random thing I made.

It’s pretty straightforward to set up.

  1. set up the formula, say for B2: “=A1+A3” and copy and paste it into all the cells underneath.

  2. Choose a cell at the top in the middle somewhere. Type “1”. It should fill in with Pascal’s Triangle automatically.

  3. Set the conditional formatting to make empty cells white and colour in multiples of the contents of one cell (I used cell I8)
    something like this: “=AND(MOD(A2,$I$8)=0,A2<>0)”

…or you could download my copy.

Creative Commons "Sharealike"

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have downloaded this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.