Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by GoreFish
-
RAG based on % complete relative to today's date and finish
Thank you for the responses! I'm quite a rookie with expressions, so your logic stating I didn't need to use the last IIF for the "red" was a new thing for me. I took your work and added some additional logic to it. I wanted to buffer my project tasks with a positive 10% buffer in favor of...- GoreFish
- Post #4
- Forum: Microsoft: Project
-
RAG based on % complete relative to today's date and finish
Hello! I've been searching far and wide for a solution to this problem and I'm striking out. What I am looking to do is have a stoplight RAG column based on a function of % Complete for a task and it its relation to today's date. Let me try to explain below: Assumes today is 7/1/11 1 Start...- GoreFish
- Thread
- Replies: 3
- Forum: Microsoft: Project
-
Is it possible to filter on uppercase in Excel 2007?
You guys are amazing! Both solutions did the trick and I learned something about putting funtions in a module to boot. I can't thank you enough StrongM and SkipVought! You're my heroes! ;) SOLVED- GoreFish
- Post #5
- Forum: Microsoft: Office
-
Is it possible to filter on uppercase in Excel 2007?
I am trying to filter a column based on the cell value being in all upper case. The example is best illustrated below. My data: A B C 1 abc 2 Def 3 GHI 4 jkl 5 Mno 6 PQR What I want to do is have the two upper case entries filtered in and the rest out (GHI and...- GoreFish
- Thread
- Replies: 4
- Forum: Microsoft: Office
