using dates formulas for conditional formatting

[dave 2015]

Hi, please can you help me with the following simple questions ..

using conditional formatting, I need formula's for the following please ..


question 1: turn a cell red if date 1 subtracted from date 2 is greater than/equal to +15 days
question 2: turn a cell red if date 1 subtracted from date 2 is between +7 to +14 days
question 3: turn a cell red if date 1 subtracted from date 2 is less than/equal to +6 days

question 4: turn a cell red if date 1 subtracted from todays date is greater than/equal to +15 days
question 5: turn a cell red if date 1 subtracted from todays date is less than/equal to -15 days

thanks in advance
Dave

[GerryZucca]

In Excel 2007+: select the range you are interested in >>>>Home ribbon tab>>>>Conditional Formatting>>>>>>New Rule...>>>>>Use a formula>>>to determine which cells to format


=$B2-$A2>=15
=E($B3-$A3>=7;$B3-$A3<=14)
=$B4-$A4>=6
=$B5-OGGI()>=15
=$B6-OGGI()<=-15

[dave 2015]

Hi Gerry, thank you very much, this was helpful.

Speak soon

D

[GerryZucca]

you are welcome!