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?