>>129217421.type 0 and 1 into two seperate cells, highlight both of them, and drag the highlight corner across as far as you want until you reach 10 or number of your choosing.
2. do this same step but for 0 and 2
3. highlight all numbers existing so far and drag the corner downward until you've laid out all increments you want probably 10 just to start. (Note this same thing can probably be achieved with the =SEQ function.
4. Go to conditional formatting and manage rules. Make new rule with format only cells that contain. Change cell value to specific text and enter digit of your choice. The go to format and fill to pick color for digit. Make sure rule applies to selected cells or all cells.
5. With coloring and numbers set, go over 1 cell and type =base(A1:K9,10,3). This will convert your numbers to a format with leading 0's which will be used to isolate singular digits.
6. With new format go over or down 1 cell and type =MID(M1:W9,3,1). This will make cause excel to scan starting from the left to 3rd number position, it will print 1 that string for each cell.
7. That's the basics, though for referencing numbers from other worksheets, in the column where you would reference cell names, use worksheet name (ex:sheet2) type sheet2!a1:k9 for the name.
