I have this lovely spreadsheet all completed and was just told the boss wants the columns 4-87 now as ROWS with the techs in the Column B.
Can someone please help me with this?
Next questions will be about conditional formatting - never done it and neither has she - but I was told I need to have the dates turn RED after 24 months past. GREEN when date is entered and also when less than 24 months. White/Clear for no data in cell.

Thank you so much in advance for any and all help. Test Worksheet.xls