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