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.