I would like a cell to change a color when it is due in the current month and another color when it is past due. I am attaching a sample file for review. There are two columns listing due dates. The dates within the current month I am in I would like to highlight yellow. Any date ranging from the previous date on I would like to highlight red. I have tried several formulas and techniques using Conditional Formatting and just can quite get it right. Can someone help?? My sanity will forever be indebted
Sample Spreadsheet1.xlsx
Bookmarks