I am trying the change the color of the cell fill when another cell is clicked on. I am able to do this if I specify a condition (ie =A3>5), but I have not been able to do this if the condition is selecting (single click) the cell.
I am trying to change the cell fill for C1 when I click on A1.
Bookmarks