Forum Discussion
MoMo71880
Aug 12, 2020Copper Contributor
Setting recurrent dates in a cell
Hi, I hope someone can help me. I have a cell with a date in it based on a formula, Cell C = A1+B1 A B C Last Order Date Order Cycle (days) Next ...
mathetes
Aug 12, 2020Silver Contributor
How is this for a simpler solution. Just use conditional formatting to turn the Next Order date red if more than seven days have passed without an update to cell A?
Here's the conditional formatting formula
I've attached a spreadsheet that uses this example.
It ends up looking like this when you haven't updated the "Last Order" date. If you have, then the cell appears as a normal (no highlight) date.