Conditional Formatting for a Date

[Sarah T Cuttings]

I have an Excel sheet where I am trying to conditional format a cell to highlight in red. I have two columns ones (E1) which shows a date of when a letter was issued and another one (F1) which has a date 7 days after that. I want F1 to highlight in red and stay highlighted once the 7 days is up.

I have tried using - Highlight cell rules, a date occuring, then selecting today. This only works if the date is today and does not highlight dates after that:

Can you let me know what I need to do to keep the date highlighted after the 7 days are up?

Thanks
Sarah

 

[kvsrinivasamurthy]

Select F1:F3
Formula
=F1<=today()

 

[Joe4]

In case it is unclear, you would use the formula from the previous post when using the "Use a formula to determine which cells to format" Conditional Formatting option.

 

[Sarah T Cuttings]

Thanks all for your help.

I don't think I was super clear in explaining myself. I want F1 to highlighted if the 7 days is up as per the date stated in the cell. I have a whole list of dates in column F which are not yet due or are blank and do not want the cell the highlight as nothing is due. Can you help me with this?

Thanks

 

[Joe4]

No, you were pretty clear. I think you just aren't understanding what we are telling you.
Do the following:

1. Select all of column F
2. Go to Conditional Formatting
3. Select the "Use a formula to determine which cells to format" option
4. Enter in the following formula:

=AND(F1>0,F1<=TODAY())

5. Choose your desired formatting option
6. Click OK.

This should do what you want, highlight all cells in column F that have dates that are today or before.

 

[Sarah T Cuttings]

Great, this worked, thanks for your help!

 

[Joe4]

You are welcome.
Glad we were able to help!