Hi Guys - hope all are well. I am trying to use a feature of excel which i have never used before.
Please see attached sample.
Basically I am trying to use the traffic light Icons in Condtional format.
Cells G3, 5, 7, 9 through 35 should have a traffric light symbol
the condition is if F3, 5, 7 through 35 is greater than D3, 5, 7 through 35 Green Light, = to Amber and < green
But I can seem to work it out.
Does anybody know?
Thanks alot guys.
Last edited by Blake 7; 01-21-2011 at 08:10 AM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
You can put a formula in column G
=IF(F3>D3,1,IF(F3=D3,0,-1))
The the CF can be set against Numbers 1 and 0 with -1 being the default Red icon.
Great idea, thanks alot Andy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks