Conditional Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top