Hello Biff,

I am curious to know the solution...
Let us say, I have define a name for the range B10:D20.
How can I use conditional formatting to format the range A1:F100 such that
only B10:D20 gets highlighted?

"T. Valko" wrote:

I need to keep changing the range of the range name

Can you be more specific about that?

You can do this with conditional formatting but you don't want to set
conditional formatting in every cell of the sheet just to identify the named
range. You have to narrow it down and be more specific.

For example, a dynamic range that might span the range A1:B500.

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
How do I set a background color to a range name? This way I can very
easily see the range of the range name. This is important because I
need to keep changing the range of the range name. I am looking for a
way to put a conditional format on a sheet or a workbook that says "if
this cell is part of the range name then set this background color or
text color." Any ideas?