VBA coding needed please

[Mustafa Evans]

Hope someone can help, i've no clue about VBA but am told that it should help me problem. I have a number of Columns in excel that hold the following data types:

Column G - Text, limited to either Routine or Urgent
Column H, I, J - Dates (dd/mm/yyyy)

If Column G appointment is "Routine" Column H should be grey and locked.
If Column G appointment is "Urgent" Columns I & J should be greyed and locked.

Columns H, I & J are populated with dates. I also need these dates to show dates that are about to expire (5 days) and the cell should be AMBER and if expired the cell should be RED.

I need these changes to happen on all workbooks within the spreadsheet.

Many thanks again in advance.

 

[Fluff]

Duplicate VBA

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).