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
