Excel for macOS; Question about DropDownMenu with Conditional Formatting

Recommended Posts


In Excel for macOS... I want to be able to create the following (see attachment) within 'Conditional Formatting', so that I can later on link towards these cells and use them in a DropDownMenu


• Can someone to explain me in detail how to create this in Conditional Formatting??

Conditional Formatting.jpg

Link to post
Share on other sites
Matthew S.

I don't think you can actually make the menu items coloured in the dropdown but you could just have conditional formatting on the cell for when the value is selected to change colour.


This link is for Windows, but it applies to the macOS version too https://www.exceltip.com/tips/create-drop-down-list-in-excel-with-color.html

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.