Hi guy I have a spreadsheet that has been setup to track "projects" ie: start date - finish date. The cells are then coloured from the start date to the finish date.
Each cell/column has a date based on 1 week ie: N10=01/01/2014, O10=08/01/2014, P10=15/01/2014. The text in these cells has been coloured white to keep it hidden from view. I have used this setup in a range of cells from "N10-MK5011" which cover a full 5 year period x 5000 entries.
Obviously the conditional formatting colours the cells based on the cell values being between "x" date and "X" date.
Now this is conditional formatting is working great but I can not add up the current jobs in each column so I need to create a VBA program to replace the conditional formatting and assign the cells a colour based on the written program.
If anyone able to assist me with this task I'd greatly appreciate it. Unfortunately I am not able to create a VBA program but I can send you a copy of the file for your review.
Thanks in advance
Thanks in advance for your help
Each cell/column has a date based on 1 week ie: N10=01/01/2014, O10=08/01/2014, P10=15/01/2014. The text in these cells has been coloured white to keep it hidden from view. I have used this setup in a range of cells from "N10-MK5011" which cover a full 5 year period x 5000 entries.
Obviously the conditional formatting colours the cells based on the cell values being between "x" date and "X" date.
Now this is conditional formatting is working great but I can not add up the current jobs in each column so I need to create a VBA program to replace the conditional formatting and assign the cells a colour based on the written program.
If anyone able to assist me with this task I'd greatly appreciate it. Unfortunately I am not able to create a VBA program but I can send you a copy of the file for your review.
Thanks in advance
Thanks in advance for your help