Format a named range with activecell condition.

[dbrizor]

Hello, new to forum and can't figure this out.

I want a named range to be outlined [bold], without changing the rest of the cell format, if the active cell is in that range. But, I also need the original format (thin outline) to return once the active cell is no longer in the named range.

EX:
I have 10 ranges named:
"range1" from A1:A10
"range2" from B1:B10
"range3" from C1:C10
...
"range10" from J1:J10

All these cells have light outline and filled light grey.
If the active cell is A4, I want named range "range1" format to change to bold outline (not single cell) only AND when the active cell leaves this range, the original format returns. Or, If the active cell is G2, I want named range "range7" do preform this, and so on.
[end EX]

Can't figure this out for some reason. Would I use Conditional Formatting? VBA? Both?

[natefarm]

In the VBA window, Project Explorer, double-click the worksheet that contains the ranges to open a code module for it, and paste in the following:

Please Login or Register  to view this content.

[dbrizor]

Thank you for your time and knowledge Sir!