Vba code to conditionally format a specific range

I'm still a rookie at this and can readily use any help y'all can provide. I need to have some VBa code to do the following things:

1. Conditionally format a range - cells in "a" should be filled in red with white bold text when value is >20
(value of a is detrmined by subtracting the date in column b from the System date auto entered in c1)

2. Prevent the user from inserting/deleting rows from the Insert menu and from the right click menu

3. Allow users to insert rows that will be properly formatted by using a button (ax:hX) - they should also be able to delete a row (ax:hx).

I realize that this is a rather large request but I am hopeful that there is indeed a generous individual in the group willing to lend me his/her expertise.

Thank you

DummyBook2.xls

Am enclosing a piece of code that was provided to me that "should get the IF statement math done" I have treid it in several different ways and can't seem to get it to work. The start date should be the date in C1 as it is the basis for the mathe. The end date should be the cells in row b, the difference in days (number)should be placed into column a for each cell in column b. I have also enclosed my dummy2 ws for reference. I really need some help. Am learning a lot and have appreciated the help received on some earlier issues.

Please Login or Register  to view this content.

DummyBook2.xls