have excel automatically fill a cell with out the fill format

[still learning]

Hi,

When I start to type a word in a cell and that word is anywhere above in the same column, the whole word will automatically show.

The problem is the cell fill format also shows.

Is there a way to only have the word without the fill

Also what is it called in the settings.

Excel 365



mike

 

[6StringJazzer]

I cannot replicate what you are describing. I get the autofill but I have never seen automatic fill.

I am going to guess you are using conditional formatting, which is giving you the fill color. Please check your conditional formatting settings and get back to us.

 

[still learning]

Hi 6StringJazzer,
Yep, It seems to have something to do with Conditional Format, although i thought i only wrote formulas to make data bold
How i found it.........
I saved it as a different name so I wouldn't destroy the original
I deleted all the macros and it still did it.
I deleted the conditional format from the entire sheet and it didn't do it.
It was the only sheet in any workbook that did it
When I have time, I'll delete one conditional format at a time and see. I don't remember but maybe I had a formula that did it. the book/sheet is a few years old.
Thanks for pointing me in the right direction

mike

Happy holidays

 

[6StringJazzer]

I would be happy to dig into it but I would need the file. If you can share it using a cloud service I'd be willing to look.

 

[still learning]

thanks
I'll try first and if i can't, I'll come back here.

mike