Forum Discussion
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 potentially applied in every cell using those labels - at its simplest adding or multiplying the two labels for that cell.
I want a user (having had the matrix explained, but with no excel competence) to click a set/series of cells and have the result of the formula appear in the clicked cell AND it to be formatted in a pre-specified way e.g. with a thick bottom border and/or filled with a specified colour. Any clicked cell should remain filled unless delete is clicked, so the picture remains on screen to be studied and the data analysed elsewhere (e.g on a different sheet).
4 Replies
A VBA event handler could be used.
The formatting can be achieved with conditional formatting.
PeterBartholomew1 thanks Peter thought that might have to be the way.
- With your permission, if I can recommend you, add a file (without sensitive data) to your project.Explain your plans in relation to this file.So you can get a solution that is tailored to your needs much faster.At the same time, it is much easier for someone who wants to help to understand the subject.A win-win situation for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Thanks Nikolino, I hope the attached clarifies what the output should look like.
