I have two sets - one of numbers between 2-6, and another is a set of 9 colors to shade the cell.
In Column A, I have excel doing =randbetween(2,6) to give me a random number.
In Column B, I would like to randomly color the entire cell with one of those 9 colors I've chosen.
How do I do the Column B? Conditional formatting is too limited. I'm using Excel 03
In Column A, I have excel doing =randbetween(2,6) to give me a random number.
In Column B, I would like to randomly color the entire cell with one of those 9 colors I've chosen.
How do I do the Column B? Conditional formatting is too limited. I'm using Excel 03
