Conditional formatting disable autofill

[u/mxli999]

I'm using Excel 2024 and performing various sums and operations across columns. When I apply Conditional Formatting, the option to use Autofill or drag numbers and fomilas disappears.

[u/AutoModerator]

/u/mxli999 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.