Forum Discussion
jackdowie
Oct 02, 2020Copper Contributor
Creating a pattern by clicking
I have an empty matrix with number labels for both rows and columns - at its simplest the numbers 1 to 10 in both cases, but they could be any real numbers. I also have a formula which is potentiall...
PeterBartholomew1
Oct 02, 2020Silver Contributor
A VBA event handler could be used.
The formatting can be achieved with conditional formatting.
- jackdowieOct 02, 2020Copper Contributor
PeterBartholomew1 thanks Peter thought that might have to be the way.