Conditional formatting causing auto complete to deactivate?
 

I have a spreadsheet in Excel 2007 that has Conditional formatting.
Auto Complete is turned on.
Is Auto Complete somehow automatically deactivated in cells that have
Conditional Formatting?

Auto Complete works as expected in the other sheets in the same workbook
that have no Conditional Formatting.

Thanks,
Bobby

Conditional formatting causing auto complete to deactivate?
 

I have not found a problem with autocomplete when cells have CF in 2007.

Are you sure you have at least one cell above with the same string?

Note: numbers do not autocomplete.


Gord Dibben MS Excel MVP

On Mon, 25 Jan 2010 13:27:01 -0800, bobby769
wrote:

I have a spreadsheet in Excel 2007 that has Conditional formatting.
Auto Complete is turned on.
Is Auto Complete somehow automatically deactivated in cells that have
Conditional Formatting?

Auto Complete works as expected in the other sheets in the same workbook
that have no Conditional Formatting.

Thanks,
Bobby

Conditional formatting causing auto complete to deactivate?
 

Yes, at least one cell has the same string.
Granted some of the strings are way up their on the sheet.
The sheet has over 20,000 rows and some of the strings haven't been used
since row 10 or 11.

Does autocomplete look back only a certain # of rows?



"Gord Dibben" wrote:

I have not found a problem with autocomplete when cells have CF in 2007.

Are you sure you have at least one cell above with the same string?

Note: numbers do not autocomplete.


Gord Dibben MS Excel MVP

On Mon, 25 Jan 2010 13:27:01 -0800, bobby769
wrote:

I have a spreadsheet in Excel 2007 that has Conditional formatting.
Auto Complete is turned on.
Is Auto Complete somehow automatically deactivated in cells that have
Conditional Formatting?

Auto Complete works as expected in the other sheets in the same workbook
that have no Conditional Formatting.

Thanks,
Bobby

.

Conditional formatting causing auto complete to deactivate?
 

I would say after a couple hundred cells Excel loses track.

That's by my own experiment. YMMD


Gord


On Sun, 28 Feb 2010 13:31:02 -0800, bobby769
wrote:

Yes, at least one cell has the same string.
Granted some of the strings are way up their on the sheet.
The sheet has over 20,000 rows and some of the strings haven't been used
since row 10 or 11.

Does autocomplete look back only a certain # of rows?



"Gord Dibben" wrote:

I have not found a problem with autocomplete when cells have CF in 2007.

Are you sure you have at least one cell above with the same string?

Note: numbers do not autocomplete.


Gord Dibben MS Excel MVP

On Mon, 25 Jan 2010 13:27:01 -0800, bobby769
wrote:

I have a spreadsheet in Excel 2007 that has Conditional formatting.
Auto Complete is turned on.
Is Auto Complete somehow automatically deactivated in cells that have
Conditional Formatting?

Auto Complete works as expected in the other sheets in the same workbook
that have no Conditional Formatting.

Thanks,
Bobby

.