I would like to have a close out date entered then when entered

If the date is 30 days or more from the current date the closeout
block becomes red behind the date
If the date is 90 days or more from the current date the closeout
block becomes Yellow behind the date
If the date is before the current date the closeout block becomes
Green behind the date
Also would like the spreadsheet to sort the rows based on the color of
the block and then by alphabetical

Red = Within 30 days AFTER C/O
Yellow = Within 90 days BEFORE C/O
Green = Current

Thanks

Chris