Microsoft Access Conditional Formatting Color Palette Choices Reduced

Angela Marie 45 Reputation points
2026-04-25T00:43:26.2733333+00:00

Microsoft Access Conditional Formatting Color Palette Choices Reduced. I used to be able to choose from about 40ish colors, then the next menu to about 100 color, then to the custom palette.

The 40ish color palette is now replaced with a simple 10 "standard colors".

At least we now have the RBG and Hex addresses, but I used the 40 color palette most of the time. Please bring it back.

Microsoft 365 and Office | Access | Development

Answer accepted by question author
George Hepworth 23,120 Reputation points Volunteer Moderator
2026-04-25T13:18:24.86+00:00

Perhaps your issue is related to one of the changes mentioned here in this Blog Post

The 5th item refers to standardizing the Access color palette to match other Office apps.

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

Answer accepted by question author
Karl Donaubauer 3,501 Reputation points MVP
2026-06-03T10:36:28.18+00:00

Hi,

The restored color palette is now mentioned (as third item) in the list of bug fixes in version 2605.

Servus
Karl


Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK

Was this answer helpful?

2 people found this answer helpful.
0 comments No comments

Answer recommended by moderator
Gustav 767 Reputation points MVP
2026-04-28T06:09:08.4166667+00:00

Angela Maria, this change is now reported to be unintended, and the older, larger palette will be back on the Conditional Formatting.

The update is still in preview, but is expected to be published with the next monthly release.

Was this answer helpful?

4 people found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2026-04-25T05:56:18.1933333+00:00

    Hi Angela Marie

    I also checked on my side and it looks the same as what you described: only 10 basic colors are available. However, I couldn’t find any official article from Microsoft about this either.

    User's image

    If I come across more information, I’ll come back to share it with you.


    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments

  2. Gustav 767 Reputation points MVP
    2026-04-25T08:53:02.6466667+00:00

    The reason behind is probably to simplify the options in the interface to select between: 10 - many - any

    Also note, that if you select your custom favourite colours and use them, they will be added to the "Recently used" row of colours (not shown on your picture).

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.