If you want to use a drop edit field, use the data validation. If you want to use a combo box, use the user form fields.
On 2/15/12, Mukesh <[email protected]> wrote: > I have 5 options which the students should select while filling up the form. > Actually it should be a combo box rather than drop down list. Please guide > me how to create a combo box in excel 2007. Thank you. > > Regards > > Mukesh Baviskar > > -------------------------------------------------- > From: "Suman Dogra" <[email protected]> > Sent: Wednesday, February 15, 2012 11:26 AM > To: <[email protected]> > Subject: Re: [AI] Conditional formatting > >> Please specify, you want to insert a combo box or a drop edit field. >> >> >> >> >> On 2/14/12, Mukesh <[email protected]> wrote: >>> Thank you. It works fine. Now I have one more query as follows: >>> >>> 1. I want to create a combo box/drop down list in cell e6. >>> 2. It should contain the words 'yes' 'no' >>> >>> How to do this? Thank you. >>> >>> Mukesh Baviskar >>> >>> -------------------------------------------------- >>> From: "zoher" <[email protected]> >>> Sent: Monday, February 13, 2012 11:44 AM >>> To: <[email protected]> >>> Subject: Re: [AI] Conditional formatting >>> >>>> yes you can do it. but the jaws will not report the right color. do the >>>> following things: >>>> 1 select the cell E5 then go to home tab by pressing alt+h. >>>> 2by pressing tab key go to stile tool bar and select conditional >>>> formatting.and hit enter. >>>> 3select heighlight cell rools submenu and hit enter. >>>> 4 select >then and hit enter and type your value 80 in your case. >>>> 5 now press tab key ones and select the color of your choice to be >>>> displayed if figure is >then 80. >>>> 6 now press tab ones and press enter on ok button. >>>> now you will notice that when the value of cell is >80 then the color of >>>> cell will be of your choice . >>>> now focose on the same cell follow the same steps above with little >>>> chainges. >>>> in step 4 we had selected >then but here select <then and press enter, >>>> and >>>> >>>> type the value as 81 in your case and select the color of your choice >>>> and >>>> hit on ok. >>>> you are done >>>> e ----- Original Message ----- >>>> From: "Mukesh" <[email protected]> >>>> To: "Access India" <[email protected]> >>>> Sent: Sunday, February 12, 2012 10:03 AM >>>> Subject: [AI] Conditional formatting >>>> >>>> >>>>> Hello Friends, >>>>> I am using M. S. Office 2007. I want to create a conditional formatting >>>>> rule for my table in Excel. The conditional formatting rule is as >>>>> follows: >>>>> 1. I want to apply rule in cell e5. >>>>> 2. If the cell value of e5 is <80, a colour of cell value should be >>>>> red. >>>>> 3. If the cell value of e5 is >=80, a colour of cell value should be >>>>> green. >>>>> >>>>> I want to apply these two conditions in a same cell e5. It is very >>>>> urgent >>>>> >>>>> for me because my work is stopped due to this problem. Waiting for your >>>>> guidance at the earliest. Thank you. >>>>> >>>>> Regards >>>>> >>>>> Mukesh Baviskar >>>>> Mobile: 9403161157 >>>>> >>>>> Search for old postings at: >>>>> http://www.mail-archive.com/[email protected]/ >>>>> >>>>> To unsubscribe send a message to >>>>> [email protected] >>>>> with the subject unsubscribe. >>>>> >>>>> To change your subscription to digest mode or make any other changes, >>>>> please visit the list home page at >>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>> >>>> >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/[email protected]/ >>>> >>>> To unsubscribe send a message to >>>> [email protected] >>>> with the subject unsubscribe. >>>> >>>> To change your subscription to digest mode or make any other changes, >>>> please visit the list home page at >>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>> >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
