I want a stop light color to change from green, yellow, or red based on a
specific number of days prior to the due date. For example:

If A1 is the stoplight color:
1) I want B8 green if the date in AE8 or AF8 is greater than 35 days prior
to the date in the field.
2) I want B8 red if the date in AE8 or AF8 is less than or equal to 35 days
prior to the date in the field.
3) I want B8 yellow if the date in AM8 or AN8 has passed.

And I need to be able to replicate this for each record.

Thanks!
Jacob