tricky Advanced Conditional Formatting
Hi all,
I have a rather tricky conditional formatting problem I need help with.
Im creating a milestone chart in MS Excel (as opposed to Project). The dates are listed along the top of the sheet and are done so according to week i.e. for Febuary 09 there are the cells for dates: 02-02, 09-02, 16-2, 23-02.
I currently have the following conditions relating to each task for dates throughout the year:
- If the start date of the task is between certain weeks (using an AND function) and the project is completed - colour the cell green
- If the start date of the task is between certain weeks (using an AND function) and the project is incomplete - colour the cell red.
Now this i where i have the problem...I need to add baseline dates..i.e. saying conditional format a cell with a border around it if the task date is between the dates.
I know I have to use VBA but i have no clue of what to write for the above action! If any1 can help it would be appreciated!
Why do you need VBA for 3 conditions?
X-post here, BTW.
Sorry I forgot to add in there is an amber status too...so 4 conditions in total!
It would probably be useful to see a sample workbook (remove any confidential info, but we still need to see where the data goes!)
Please also read this article on Crossposting:
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks