Even though a spreadsheet cell can be colored based on its current value (using conditional settings), is there a way that a cell (when clicked) could color specific other cell/cells?. Sort of ‘if clicked’ it just makes the nominated cell/cells a color? (used here just to temporary visual hilite for me). Would also like to have another cell to turn them another color too but assume thats just a repeat of the function requested above (with different colors).
An XY problem sensed … are you looking for precedents/dependence tracing in Tools → Detective?
1 Like