Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Getting The Green Light Conditional Format In Excel Worksheets.mp4

K2 Enterprises
5.09K subscribers
24K views 14 years ago
As many Excel 2007 and Excel 2010 users know, one of the enhanced conditional formats available in those versions of Excel is that of traffic lights. Traffic light conditional formats allow users to segment or stratify data into three tiers -- red light, yellow light, and green light. But what if we only wanted to see just the data that meets the green light criteria? How can we modify the conditional formatting rules in Excel 2007/2010 to change the way traffic light conditional formatting is applied? Fortunately, the answer is quite simple. ...more
...more
Getting The Green Light Conditional Format In Excel Worksheets.mp4
11Likes
24,810Views
2011Mar 22
As many Excel 2007 and Excel 2010 users know, one of the enhanced conditional formats available in those versions of Excel is that of traffic lights. Traffic light conditional formats allow users to segment or stratify data into three tiers -- red light, yellow light, and green light. But what if we only wanted to see just the data that meets the green light criteria? How can we modify the conditional formatting rules in Excel 2007/2010 to change the way traffic light conditional formatting is applied? Fortunately, the answer is quite simple.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers