Fill Color Formatting Suddenly Stopped

[JJM Limited]

Hello,

How are you?

Currently, I am working on a government project wherein I line up columns and rows of numbers and values. I began inputting the numbers then, highlighting ones that are arranged to a particular project and date. Then, Excel began to fill-in the highlight automatically. Some highlights were correct.

Now and suddenly, the auto-fill highlight has stopped. I checked the 'Advanced Options' and all pertinent buttons appear to be 'On.' Also, have restarted. I am not sure if I might have checked/not-checked a copy button.

Any solutions to having the highlighted cells to begin auto-fill-in once again please?

Best regards

[mcmahobt]

Can you upload a sample workbook that does not contain sensitive data?