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
