(Msg. 1) Posted: Fri Oct 24, 2008 8:10 am
Post subject: Change color of Drop Down List (Validation box) Archived from groups: microsoft>public>excel>setup (more info?)
I am creating a form in which there is a column with drop down list where
users select answers. I do not want the answers to be distinguished from the
rest of the form in any color or format after being selected. How do I make
the drop down list to stand out in color or any format in the form so users
know they need to select answers for that column. But after all answers
selected from drop down, the answers columns look the same as the rest of the
sheet? Any help is appreciated. Thank you.
(Msg. 2) Posted: Sat Oct 25, 2008 6:00 pm
Post subject: Re: Change color of Drop Down List (Validation box) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Kaylen
As well as applying DV, also select the same range and apply Conditional
Formatting.
Assuming that data is in column A,
Format>Conditional Formatting>Formula is> =$A1="" >Format>Fill colour>Choose
whatever colour you wish.
--
Regards
Roger Govier
"Kaylen" <Kaylen RemoveThis @discussions.microsoft.com> wrote in message
news:8626AF70-DC35-48D5-998C-9013D97BC6B9@microsoft.com...
> I am creating a form in which there is a column with drop down list where
> users select answers. I do not want the answers to be distinguished from
> the
> rest of the form in any color or format after being selected. How do I
> make
> the drop down list to stand out in color or any format in the form so
> users
> know they need to select answers for that column. But after all answers
> selected from drop down, the answers columns look the same as the rest of
> the
> sheet? Any help is appreciated. Thank you.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum