Conditional Formatting with dates and highlights
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula?
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula? Read More