mike.lewis
Board Regular
- Joined
- Nov 29, 2009
- Messages
- 196
Hi There
i am setting up some traffic light alerting in excel 2010
my issue is around getting the "lights" to respond to my desired range.
basically what i need is for the range to be green for anything below 1 min ( or we can work off 15 min intervals if easier ) then anything above one minute red.
The ideal format i want to use is hh:mm, i can even go with h:mm ( so 1.25 for 1 hour 15 minutes )
Help !!!!
i am setting up some traffic light alerting in excel 2010
my issue is around getting the "lights" to respond to my desired range.
basically what i need is for the range to be green for anything below 1 min ( or we can work off 15 min intervals if easier ) then anything above one minute red.
The ideal format i want to use is hh:mm, i can even go with h:mm ( so 1.25 for 1 hour 15 minutes )
Help !!!!