Need help with Excel conditional formatting. I have already posted this question once and they just did a copy and pasted general excel help guide which didn't cover the issue. Below the initial question are more details clarifying since I evidently did a bad job clarifying.

Need to find the conditional formatting function to use in an Excel to input to change dates within multiple columns/rows to fill red for dates that past current date, yellow for coming due within next month, and green for further out. Column F, row 2 thru Column T Row 391

Ex. $F$2:$T$391

End result is any dates that are overdue (beyond today's date) in column rows $F$2:$T$391 need to be Red fill. Any dates that are within the next month need to be Yellow Fill, and any dates that are more than a month from today are green fill with is each updating for the current date.