I have a basic thrown together, but I can't get the conditional formatting to work.
Yellow - 60-90 days to renewal
Orange - 30-60 days to renewal
Red <30 days to renewal
edit:
I got it working. I'll go over it w/ the OP (PM sent) and see what he thinks, maybe I'll offer it to the forum.
I've made a basic spreadsheet. Nothing great (really basic).
The renewal date will be:
Yellow if it is between 61 and 90 days to the expiration date,
Orange if it is between 31 and 60 days
Red if it is less than 30 days
Also, the "profit" field:
Green = profit
Yellow = Brake even
Red = Loss
PM me your email if you'd like to see a copy (To keep distribution small, I'll only send out 5)