I don't know how to do it in office 7. but I know it in office xp. if you need it, I can explain.

Umesha

----- Original Message ----- From: "Mukesh" <[email protected]>
To: "Access India" <[email protected]>
Sent: Sunday, 12 February, 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

Reply via email to