Conditional Formatting for 7 days overdue

[Jordan_YBC]

Hello everybody,

First time poster so please pardon my lack of knowledge in regards to excel.
I have designed a spread sheet in order to track purchase orders and have had some trouble in regards to highlighting cells based on orders overdue by 7 days+
I would like to remove the 2 rules for 'last week' & 'last month' and replace these with 1 rule to highlight all cells overdue by 7 days+ red with white text, any help is much appreciated!

thanks in advance,

- Jordan

 

[etaf]

TRT

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
I2:I100 - Change, reduce or extend the rows to meet your data range of rows - Not sure what column

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(I2<>"",I2<Today()-7)

Format [Number, Font, Border, Fill] - set fill for Red and Font White
choose the format you would like to apply when the condition is true
OK >> OK

 

[Jordan_YBC]

Thank you etaf thats done the trick!

I made some slight changes as follows
=AND(I1<>"",I1<TODAY()-6)

Now we're up and running, thanks again

 

[etaf]

you are welcome