Conditional Formatting Range
 

I have selected a range for conditional formatting. It works fine. However,
when I type outside that range, the conditional formatting applies there too.
For instance, if I have set up a range of A1:A10 to highlight in yellow and
I type a number greater than 100, this condition seems to apply to A11 too.
Shouldn't it apply to only the selected range? The condition seems to apply
to the next column too. Any information would be greatly appreciated.

Conditional Formatting Range
 

Exactly what formula did you use in CF?

When you select a range prior to invoking CF, the CF formula should refer to
the cell in focus, and use relative references.

For example - click in A1 and drag down to A10 - to select the range A1:A10.

You'll see that A1 is white, denoting that A1 is the cell in focus.

Your CF formula should have a relative reference to A1:

=A1100

Click on <Format and make your choices, then <OK <OK.

You should now have *only* A1 to A10 included in your CF.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===




"Jean" wrote in message
...
I have selected a range for conditional formatting. It works fine.
However,
when I type outside that range, the conditional formatting applies there
too.
For instance, if I have set up a range of A1:A10 to highlight in yellow and
I type a number greater than 100, this condition seems to apply to A11 too.
Shouldn't it apply to only the selected range? The condition seems to apply
to the next column too. Any information would be greatly appreciated.

Conditional Formatting Range
 

When you select A11 and look at Format/ Conditional Formatting, what do you
see? If you have a condition set there, you can delete it. Did you perhaps
originally set up the condition to apply to A1:A10 and then insert a cell
within that range, or insert a row?

If the formatting seems to be applying in column B, too, then again select
the relevant cells and look at Format/ Conditional Formatting.
--
David Biddulph

"Jean" wrote in message
...
I have selected a range for conditional formatting. It works fine.
However,
when I type outside that range, the conditional formatting applies there
too.
For instance, if I have set up a range of A1:A10 to highlight in yellow
and
I type a number greater than 100, this condition seems to apply to A11
too.
Shouldn't it apply to only the selected range? The condition seems to
apply
to the next column too. Any information would be greatly appreciated.

Conditional Formatting Range
 

No, I just checked and there is no CF in cell A11. However, when I typed a
200 in cell C11, CF was applied. I don't want it to be applied outside of my
selected range. Actually, I just did this again on a brand new spreadsheet,
and the issue exists there too. This is very curious.

"David Biddulph" wrote:

When you select A11 and look at Format/ Conditional Formatting, what do you
see? If you have a condition set there, you can delete it. Did you perhaps
originally set up the condition to apply to A1:A10 and then insert a cell
within that range, or insert a row?

If the formatting seems to be applying in column B, too, then again select
the relevant cells and look at Format/ Conditional Formatting.
--
David Biddulph

"Jean" wrote in message
...
I have selected a range for conditional formatting. It works fine.
However,
when I type outside that range, the conditional formatting applies there
too.
For instance, if I have set up a range of A1:A10 to highlight in yellow
and
I type a number greater than 100, this condition seems to apply to A11
too.
Shouldn't it apply to only the selected range? The condition seems to
apply
to the next column too. Any information would be greatly appreciated.

Conditional Formatting Range
 

My CF formula in cells A1:A10 is "Cell Value is Greater than or equal to
100." I just checked and there is no CF in cell A11. However, when I typed
a 200 in cell C11, CF was applied. I don't want it to be applied outside of
my selected range. Actually, I just did this again on a brand new
spreadsheet, and the issue exists there too. This is very curious.

"RagDyeR" wrote:

Exactly what formula did you use in CF?

When you select a range prior to invoking CF, the CF formula should refer to
the cell in focus, and use relative references.

For example - click in A1 and drag down to A10 - to select the range A1:A10.

You'll see that A1 is white, denoting that A1 is the cell in focus.

Your CF formula should have a relative reference to A1:

=A1100

Click on <Format and make your choices, then <OK <OK.

You should now have *only* A1 to A10 included in your CF.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===




"Jean" wrote in message
...
I have selected a range for conditional formatting. It works fine.
However,
when I type outside that range, the conditional formatting applies there
too.
For instance, if I have set up a range of A1:A10 to highlight in yellow and
I type a number greater than 100, this condition seems to apply to A11 too.
Shouldn't it apply to only the selected range? The condition seems to apply
to the next column too. Any information would be greatly appreciated.

Conditional Formatting Range
 

From the menu bar:

<Tools <Options <Edit tab,

*UNCHECK*
"Extend List Formats & Formulas"

This feature will *extend* CF when CF appears in at least 3 of the 5 last
rows preceding the new row.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jean" wrote in message
...
My CF formula in cells A1:A10 is "Cell Value is Greater than or equal to
100." I just checked and there is no CF in cell A11. However, when I
typed
a 200 in cell C11, CF was applied. I don't want it to be applied outside
of
my selected range. Actually, I just did this again on a brand new
spreadsheet, and the issue exists there too. This is very curious.

"RagDyeR" wrote:

Exactly what formula did you use in CF?

When you select a range prior to invoking CF, the CF formula should refer
to
the cell in focus, and use relative references.

For example - click in A1 and drag down to A10 - to select the range
A1:A10.

You'll see that A1 is white, denoting that A1 is the cell in focus.

Your CF formula should have a relative reference to A1:

=A1100

Click on <Format and make your choices, then <OK <OK.

You should now have *only* A1 to A10 included in your CF.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===




"Jean" wrote in message
...
I have selected a range for conditional formatting. It works fine.
However,
when I type outside that range, the conditional formatting applies there
too.
For instance, if I have set up a range of A1:A10 to highlight in yellow
and
I type a number greater than 100, this condition seems to apply to A11
too.
Shouldn't it apply to only the selected range? The condition seems to
apply
to the next column too. Any information would be greatly appreciated.