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/

 

[faalin]

Down and dirty way.

I added the format for the cells at the bottom just take the () off
Column C is formatted for dates and column D is formatted for numbers with no decimals.

Then highlight column D and go to conditional formatting, select new rule, and Format all cells based on their values.

For type select number
minimum value set to 29 color green
maximum value set to 30 color red

To get the current date do =TODAY() in the cell