I need help with a conditional formatting with dates.
If the cell dates is past now(), then I need to show red,
If the cell is past now but within the next 6 months from now(), then I need to show yellow.
If the cell date is more than 6 months from now then it can show green.

Thanks, LaDonna