• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

Sign in to follow this  

Excel for macOS; Question about DropDownMenu with Conditional Formatting

Recommended Posts

Genesis1982    6

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

Share this post

Link to post
Share on other sites
Matthew S.    999

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

Share this post

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.