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.
|