Defined name = Range = B10:D20

Create this named formula:

**Select cell A1** This is important!
InsertNameDefine
Name: InRange
Refers to:

=NOT(ISERROR(Range A1))

OK

Note the space between Range and A1. That is intentional.

Apply the conditional formatting:

Select the range A1:F100
Conditional Formatting
Formula Is: =InRange
Set a nice fill color
OK out

You could also do it by testing the cells row/column numbers to be within
the row/column numbers of the named range but the above method is less
complicated.

--
Biff
Microsoft Excel MVP


"Sheeloo" wrote in message
...
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?