LinkBack URL
About LinkBacks
Hi all
I am trying to make a drop down list in excel that would let me choose the color (instead of having text with RED, AMBER, GREEN just to select the respective color). Is this something that can be done? I am using Excel 2010
Thank you.
Hi all
I am trying to make a drop down list in excel that would let me choose the color (instead of having text with RED, AMBER, GREEN just to select the respective color). Is this something that can be done? I am using Excel 2010
Thank you.
use data validation list as 1,2,3 and use conditional format
if cell selection was 1 Red
if cell selection was 2 Amber
if cell selection was 3 Green
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you for the very fast answer. Could you be more specific please? I know how to make a list and use conditional format but I guess I didnt fully understand ur answer?
Hi,
Check out this example of picking color
Please Login or Register to view this content.
see the attached fileOriginally Posted by GPetcu
Application.Dialogs(xlDialogEditColor).Show(40, 100, 100, 200) this seems to be wrong. Getting syntax error. Any ideeas?
Change
Please Login or Register to view this content.
@nflsales That was just what I needed. Thank you. Now I have one more question. Would it be possible to add custom written text to the cell after I colored it?
I have attached a small example of what I am looking to do with this document. New Microsoft Excel Worksheet.xlsx
in this case use helper column and hide the same in my attached file use the validation /conditional formatted cells column as helper column and hide the same when ever necessary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks