Highlight Based on Dates, but NOT Current Date

[MacroTemp]

I'm really having a hard time finding an answer to this, since every single post I check only uses "TODAY" in the formula.

I have dates in two columns--Column F and Column G. I need to conditionally highlight Red any dates in Column G that are 5 days or more past the corresponding date in Column F.

Example: In Cell F2 is 05/05/2016, and in Cell G2 is 11/05/2016. In this case, G2 needs to highlight Red because it is over 5 days beyond the date in F2. But it has nothing to do with the current date. I also need to exclude blanks from the formula, but I will probably just add a separate rule for that.

I know this has got to be very easy, but what I'm looking for is being overlapped by a much more common search! And I'm a bit too novice to know what I'm doing enough that I can play around with formula. Any help would be much appreciated!

 

[Joe4]

Just subtract the two dates (which will return the number of days), i.e.

=G1-F1>=5

If you want to make sure neither date is blank, you can use:

=AND(G1>0,F1>0,G1-F1>=5)

 

[MacroTemp]

That worked like gangbusters! And you got back to me so fast...a lifesaver, my friend. Thanks very much. SOLVED! And bookmarked lol.

 

[Joe4]

You are welcome!
Glad I could help!