How to Highlight A Cell when Another Cell Is Selected

5thQuadrant

New member
Joined
Mar 18, 2021
Messages
20
Reaction score
0
Points
0
Excel Version(s)
MS 365 for Enterprise
I can highlight a cell "A1" if another cell "C1" = 5.

However, I can't figure out the following.
Regardless the value of "C1" I am now trying to highlight "A1" when "C1" is selected by mouse and "A1" won't be highlighted if "C1" is not selected by mouse.
How to make this work?
Your help is much appreciated.
 
This is not possible with a formula. For this reason rather a question for the VBA forum.
 
Back
Top