Change Font Color on Selection within Named Range

[FallingDown]

Hi all

In my file, I have named the col. Q as "MyRange1"

The user has to select one or more lines within this file and run a macro
This macro re-colors the cells.
However, I would like the cells in col. Q (cells within "MyRange1") to be colored differently.

How would I achive this?

(Adding a separate line of code simply re-coloring Q is not practical, as there are many more named ranges, and cols might shift at any time)

Thanks
FD

[StuCram]

Try this: (Change the colours to ones you like)

Please Login or Register  to view this content.

[FallingDown]

Hi there.
Thank you very much, this helped

Is there a particular reason why you use two lines of code in this section

Please Login or Register  to view this content.

I have re-coded it to

Please Login or Register  to view this content.

Just curious and for future reference.

[StuCram]

I usually do that in case there other lines of code to add that would affect the range, perhaps adding a border or changing the text style.
Just my habit.