Formula or Excel solution?
I need to highlight different start dates (e.g., April 22, 2023) in a cell in red if they are two years old. In other words, the cell should turn red when two years have passed since April 22, 2023. The problem is that I can't use the today formula because, on the one hand, the date lies in the past of today, and, on the other hand, it's not otherwise transferable to other dates.
Is there a formal or formatting rule that does exactly this? I've tried hundreds of things without success:
The fact is that in my case the formula approach with today's date does not work, maybe someone can help
Hello,
an example:
The date is to be dyed in A1 the cell B1.
Select Cell B1 – Conditional Formatting – New Rule – Use formula to determine the cell to be formatted – insert the following formula:
TAX(A$1>=720)
Greeting Nepumuk
I can’t. In a cell, only one value (here: date) can be a formula, not both. In addition, one cannot change the content of a cell from another cell, but only the content of the cell in which the formula is seen.