excel conditional formatting
-
Friday, May 04, 2012 7:13 AMI want to apply conditional format on a column, such that in any cell of that column if the vale is between -20 and 20, cell color should be green otherwise red...
- Moved by Max MengMicrosoft Contingent Staff, Moderator Monday, May 07, 2012 2:01 AM Moving to a more appropriate forum (From:Visio General Questions and Answers for IT Professionals)
All Replies
-
Monday, May 07, 2012 9:13 AM
Download the link http://www.sendspace.com/file/r1e07w
(In home tab->Conditional Formatting->Mange Rule -)
See and experiment a bit.
- Marked As Answer by Jaynet ZhangMicrosoft Contingent Staff, Moderator Monday, May 14, 2012 9:34 AM
-
Monday, May 07, 2012 9:20 AMModerator
Hi,
I agree with Learning and Learning and the file uploaded has accomplished the goal.
Here's a link about Creating conditional formatting formulas:
Jaynet Zhang
TechNet Community Support
- Edited by Jaynet ZhangMicrosoft Contingent Staff, Moderator Friday, May 11, 2012 3:29 AM
-
Monday, May 07, 2012 1:34 PM
Hello,
Follow the links below. It will help you.
http://www.addictivetips.com/microsoft-office/change-color-cells-in-excel-2010-using-color-scales/
http://www.techrepublic.com/blog/msoffice/how-to-use-excel-2010s-new-conditional-formatting-with-references/3727
http://www.dummies.com/how-to/content/how-to-apply-conditional-formatting-in-excel-2010.html
.png)
