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