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
