G
Guest
i want the choices to be formated in different colors, or bold or italics, etc.
V
VBA Noob
Think your after Conditional Formatting.
e.g if cell value = 3 you could change the format to Bold and Red
Font.
VBA Noob
e.g if cell value = 3 you could change the format to Bold and Red
Font.
VBA Noob
N
Nick Hodge
Sam
You can't
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
You can't
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
G
Guest
you can, because i am working in a spredsheet that someone else created that
does. but how?
does. but how?
N
Nick Hodge
Sam
As I pointed out I have maybe misunderstood that you wanted the items in the
dropdown different colour etc.
Maybe you should re-describe what you are looking to do and either myself or
another person will let you know the answer
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
As I pointed out I have maybe misunderstood that you wanted the items in the
dropdown different colour etc.
Maybe you should re-describe what you are looking to do and either myself or
another person will let you know the answer
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
G
Guest
i see the misunderstanding. i wanted to change color of the item that was
selected and put in the cell, not the color of the list itself. i think i
found the answer with conditional formating, it works well and is actually
fairly inteligble without a manual. thanks for your help.
selected and put in the cell, not the color of the list itself. i think i
found the answer with conditional formating, it works well and is actually
fairly inteligble without a manual. thanks for your help.
X
xtrmhyper
yes you can just select the cell you want to color then click format to
the menu
bar then select the conditional formatting
the menu
bar then select the conditional formatting