Hi. Need some advise in Excel 2007. Was searching the forums for this info, but could not find any.
Is it possible to insert colour text in a dropdown list. I want the MAIN SUBJECT to be BOLD and in a different colour from the text listed below the SUBJECT.
Example : HEADERS >> YEAR 2011, YEAR 2012, YEAR 2013 IN RED AND BOLD while the content listed below that, to be normal, black text.
So once you click on the dropdown list, it will be easy to scroll down to the heading you want as my list is long with so many different listings below each HEADER (SUBJECT).
I do not want the box or column to change colour, just the text inside the dropdown list to be in colour to make it easier to see the text from the headers.
For example.
YEAR 2011
Jan-11
Feb-11
Mar-11
Apr-11
May-11
Jun-11
Jul-11
Aug-11
Sep-11
Oct-11
Nov-11
Dec-11
YEAR 2012
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
YEAR 2013
Jan-13
Feb-13
Mar-13
Apr-13
May-13
Jun-13
Jul-13
Aug-13
Sep-13
Oct-13
Nov-13
Dec-13
Thank you
Bookmarks