WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Change color of Drop Down List (Validation box)

 
   Home -> Office -> Setup RSS
Next:  Navigation Toolbar for Exel created by Dave Peter..  
Author Message
Kaylen

External


Since: May 07, 2008
Posts: 19



(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.
Back to top
Login to vote
Roger Govier

External


Since: Nov 28, 2007
Posts: 1113



(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.
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Setup 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET