Conditional Format

I

Ian Belcher

Hi,
I've got some conditional formatting in some columns but not others. When I
enter data in a row moving from one column to the next and I get to a column
with no CF, Excel copies accros the CF from the previous column. Is this a
'Helpful' idea by Excel and if so can I turn it off? If it's not does anyone
know how I can fix the columns with no conidtion to stay with the original
formatting?

Thanks
Ian
 
R

RagDyeR

Try this:

<Tools> <Options> <Edit> tab,

And *UNCHECK*

"Extend list formats and formulas".
--

HTH,

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

Hi,
I've got some conditional formatting in some columns but not others. When I
enter data in a row moving from one column to the next and I get to a column
with no CF, Excel copies accros the CF from the previous column. Is this a
'Helpful' idea by Excel and if so can I turn it off? If it's not does
anyone
know how I can fix the columns with no conidtion to stay with the original
formatting?

Thanks
Ian
 
Top