- Mar 23, 2006
I have to run query in lot of worksheets everyday. All my worksheets have query at the same cell, say cell A34. Just for convenience, I want to put a color switch in some other cell, say J1. The switch should turn green when cell A34 is selected and should turn red when not selected. Any suggestions?