What you see at that site is VBA event code not Conditional
Formatting.
You will need event code to do what you want.
What do you want displayed in D9:F9 if A5 is not the active cell?
Gord
On Wed, 18 Apr 2012 20:11:27 +0000, Jwalters
wrote:
I am attempting to perform a conditional formatting function. If the
cursor is in A5, then I want a range of cells, let's say a50:c54
displayed in cells d5:f9. I came across some conditional formatting
code that change a cell's color based on cursor position,
http://www.excelbanter.com/showthrea...oto=nextoldest
Thanks.