Hi everyone,

ResourceAllocationProposal_SatpalJ.xls
Problem 1:
I want to highlight all those values in the general allocation sheet whose value is greater then the threshold value in sheet support.For example
For satpal threshold value is 40% so if i go to general allocation sheet ,i will check against satpal and if any value is greater then 40% then highlight the way i m highlighting it right now.

Problem 2:
If you see in general allocation sheet, the row numbers are automatically changed , who to avoid that?

Problem 3:
I want to restrict user to enter anything in general allocation sheet through programming how can i do that?

Problem 4:
I want to create a template of sheet Allocation in which if a person wants to add a project then automatically it get the way i have.
I mean same height of cell for project name , and say atleast 1 row for the name and effort (june july....) etc. Can i do this in Vba?

Problem 5:
Even though i have validation on column name in allocation sheet, but after row no 30 its not applicable. The reason being I have set that range but I dont wanna let user enter anything after that row. What should i do to prevent this.