Question How to detect rows if it has been a certain time in Microsoft Excel ?

[MemoryCard]

I want to use Excel table to notice deadlines. I wrote different dates on multiple rows. Each row has to inform me (with color change or something else) one month after.
For example;
Row 1: 20/08/2024 -> There should be an indicator starting from 20/09/2024 and later.
Row 2: 18/09/2024 -> There should be an indicator starting from 18/10/2024 and later.
Could you please explain how to do it?

 

[Ralston18]

Excel: The general topic is "Conditional Formatting".

You create rules that compare the dates and if the difference between the dates is > or = 30 days then change the cell color or font in the applicable column.

Do some testing and if not successful then post the rules that you are trying to apply to the requirement.

Start here (chosen at random from the many online links and tutorials available.)

https://www.ablebits.com/office-addins-blog/excel-conditional-formatting/