Conditional Formatting Range

[Jean]

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.

 

[RagDyeR]

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:

=A1>100

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!
=====================================================




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.

 

[David Biddulph]

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.

 

[Jean]

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.

 

[Jean]

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]

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.