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

(1 votes)
Loading...

Similar Posts

Subscribe
Notify of
2 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Nepumuk7
1 year ago

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

Dietwald2016
1 year ago

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.