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)
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
I agree with Learning and Learning and the file uploaded has accomplished the goal.
Here's a link about Creating conditional formatting formulas:
TechNet Community Support
- Edited by Jaynet ZhangMicrosoft Contingent Staff, Moderator Friday, May 11, 2012 3:29 AM
Monday, May 07, 2012 1:34 PM
Follow the links below. It will help you.