Desired format for a worksheet.

[neaz1st]

I attached herewith a XL file, I am in the need of following:

1. Color background of date cell - GRAY for tasks "older" than "today" (whatever that is) when the sheet is opened refreshed, and YELLOW for "today" and "tomorrow", and no background coloring for the rest.

2. Color font of date cell - RED if "today".

3. Insert Row - Provide insert row button to insert an empty row at the top that prompts for 1 empty row by default.

4. Selectable calendar - When any date is clicked, a calendar should appear with "today" highlighted. Clicking on today or any other date should close the calendar and insert the date.

if anyone can help, please write enough comment (inside the code) in each numbered items above so that it will be easier for me to learn. please ensure the above criteria for the whole sheet so that i get the same output as i update the sheet.
regards

[protonLeah]

This is a HELP forum, not a development agency. Please do not post design requirements and wait for someone to do your work for you. Try conditional formatting, if you can't get it to work, then post the product of your efforts so we can show you where you went wrong. You should, at least, try!

[Mordred]

I totally agree with protonLeah, you haven't even tried to set this up for yourself. Also, you shouldn't provide sensitive and personal data, and your workbook has just that. I would suggest that you reupload a workbook without full names and phone numbers. This is a public forum where people donate their time, experience, and ability. Given that this is public, any one person here could use the sensitive data against he person and I'm pretty sure that the person you named wouldn't like having their information out there for everyone to see.

[Winon]

@ protonLeah,

This is a HELP forum, not a development agency.

LOL

I shall remember and use this line where applicable.

@ Mordred,

A very good point you make about personal information, and possible legal actions etc.