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.