Help with Nested IF AND Statement

Hello,
My team and I have been working on logic for a report, but we cannot get it to work accurately across all criteria that we need it for.
Here's the logic that we need to include:
1. If Column AP is "CPU", and Column AE is <= Column AD, return "Green"
2. If Column AP is "CPU," and Column AE is "", and Column AD is within 3 days of today, return "Yellow"
3. If Column AP is "CPU," and Column AE is "", and Column AD is < today, return "Red"
4. If Column AP is "CPU", and Column AE is > Column AD, return "Red"
5. If Column AP is not "CPU", and Column AE is <= Column AD, return "Green"
6. If Column AP is not "CPU", and Column AE is "", and Column AN is within 3 days of today, return "Yellow"
7. If Column AP is not "CPU", and Column AE is "", and Column AN is < today, return "Red"
8. If Column AP is not "CPU", and Column AE is >Column AD, return "Red"

If anyone is able to assist, we would be very grateful!