Highlight cell after a time period expires

[trevolly]

Hi all

Hope you're all well. I have a daily log for work where we type issues in a table. This table is made of a column for entering the date of the issue and then the next column along contains the issue. Is there a way of highlighting the cell with the issue in if the date column expires a certain time scale, say 7 days? This would then enable staff to be alerted of an ongoing issue and then chase it where needed.

I tried conditional formatting with a rule of =(B28:B50)>=7 but it just colours (by conditional formatting) the text as red no matter what date is in the date column

Thanks for your time all

T

 

[Fluff]

If your dates are real dates & not text select D28:D50 & use this formula

=B28>=TODAY()-7

 

[trevolly]

Hi thanks for the reply. Not sure what you mean by "real dates". The cell with the date in is typed ie: 29/09/21 and then cell is formatted to see a date format. I tried your formula in conditional formatting and it turn the text red no matter what date is entered. Thanks thou

 

[Fluff]

With todays date of the 29th what dates should get highlighted?

 

[trevolly]

If we were using todays date (29th) I was hoping to highlight anything +7 days and more from now. So from the 06/10/21 (and beyond) in this case it would highlight.

Its just staff type in information to this sheet in the layout I posted (typing a date in the "date column" and then the issue in the next column) but then that data just sits there and goes out of date..... I wanted to be able to put a timescale on the issue and then staff either follow up the issue or delete the out of date issue.

Thanks for your time

 

[Fluff]

I was hoping to highlight anything +7 days and more from now.

In that case use +7 rather than -7

 

[trevolly]

Ok many thanks I'll give that a go

 

[Fluff]

Ok