Hello, I am looking to format a cell color based on a day of the month, if "Today" is close to or past a certain day of the month.
I have a spreadsheet for my Budget. I have items like Credit-Cards, Utilities in each Row, and I have a Column for Budgeted, and Actual amounts.
I want to have the cell for (Discover, Visa, etc.) change color when it’s getting close to and past the due day.
I want it to turn yellow if "Today" is within say 6 days from now/today, and then turn Red if Today is within 2 days from now, and stay Red until something is entered in the “Actual” cell that is next to it.
(e.g. If Discover is due on the 10th or 10th Day of each month then the cell will turn Yellow on the 4th Day, and then turn Red on the 8th Day, and stay Red until I enter my Payment Amount in the “Actual” Column for that Row.)
I hope I have given a good explanation of what I am trying to do.
Thanks for the help.
Steve
Bookmarks