Not sure if your last condition was meant to read AE & AF, or if you really
meant AM & AN (possible typo?). As you said it, should setup this way:

format - conditional format
Condition 1, formula is:
=OR(TODAY()AM8,TODAY()AN8)
Choose yellow pattern

Condition 2, formula is:
=OR(AE8B8-35,AF8B8-35)
Choose green pattern

Condition 3, formula is:
=OR(AE8<=B8-35,AF8<=B8-35)
Choose red pattern

You should be able to copy this format to other cells as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Morgimo" wrote:

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