I’m working in Excel, trying to find a solution to a problem. I’ll try to explain. I have a ditty of a script that when a cell is clicked on it cycles through a range of 5 colours, on the same row that the cell is clicked on is some data, I can retrieve this data in VBA ok, on another sheet is the same data. I want to colour a cell 2 rows up from where the cell matches the one on the first page.
I’ve tried differing tools but can’t find a good solution, please help.