Hello,

I am looking to see if it is possible to automatically change the colors of
cells in accordance with a number....

ie. I have a list of numbers, lets say Ten rows long, 3 numbers per row,
preset from 1 - 5

Row.1 1, 2, 3
Row.2 1, 2, 5
Row.3 3, 4, 5
Row.4 2, 4, 5

etc.

I would like to take that list and have it prefill another worksheet, with a
black color pattern, that have the numbers in the cell
Col.1 Col.2 Col.3 Col.4......
Row.1 1 1 1 1
Row.2 2 2 2 2
Row.3 3 3 3 3
Row.4 4 4 4 4
Row.5 5 5 5 5

I am unsure if it would be a Macro or some type of automatic formula.

Thank you.