daedalus
09-18-2008, 02:16 PM
I am making a tracking spreadsheet and I want it to highlight certian columns for certian events to aid in project management while building a nuclear plant which has thousands of procedures. Basically making it easy to follow as the project goes on. I was going to use conditional formating but it was getting excessive and would be easier to do with a Macro. I have never writen a macro with VBA but once I have one that works I will be able to edit it and understand what to do somewhat.
Basically the format looks like the attachment(excel 2003)
I want it to show the row in green if before the start date, yellow after the start date, and red if not approved before the completion date. Once it is approved I would like the entire row up to the Approved Column to be green.
Then the ITAACs columns I want to make it so that if there are >0 the block shows up in red unless the ITAAC's completed column is equal to the ITAAC's involved column. If the columns are more than 0 and equal I would like them to be Green again.
Once the Completed box is checked I would like it to be green all the way accross the board(however it cannot be complete unless all ITAAC's are completed so I want the ITAAC's to remain seperate I don'twant them turning green just because someone puts an X in the complete column)
I hope you can follow that train of logic if not send me a PM and I will try to make sense of it. I am a Nuclear Mechanic so computers are more a hobby than anything so this is a little out of my normal element.
Thanks greatly I realize this is somewhat a complicated request even if you can just provide bits and pieces of the code I will try to piece it together as needed to make it work. I hope someone enjoys a good challenge.
Basically the format looks like the attachment(excel 2003)
I want it to show the row in green if before the start date, yellow after the start date, and red if not approved before the completion date. Once it is approved I would like the entire row up to the Approved Column to be green.
Then the ITAACs columns I want to make it so that if there are >0 the block shows up in red unless the ITAAC's completed column is equal to the ITAAC's involved column. If the columns are more than 0 and equal I would like them to be Green again.
Once the Completed box is checked I would like it to be green all the way accross the board(however it cannot be complete unless all ITAAC's are completed so I want the ITAAC's to remain seperate I don'twant them turning green just because someone puts an X in the complete column)
I hope you can follow that train of logic if not send me a PM and I will try to make sense of it. I am a Nuclear Mechanic so computers are more a hobby than anything so this is a little out of my normal element.
Thanks greatly I realize this is somewhat a complicated request even if you can just provide bits and pieces of the code I will try to piece it together as needed to make it work. I hope someone enjoys a good challenge.