Using conditional formatting with Dates

[Newbienew]

I am trying to use conditional formatting with dates in the form of 30 days out 60 days out and 90 days<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-weight: 700; border: 0.5pt solid windowtext; }.xl64 { border: 0.5pt solid windowtext; }</style>

30 days	60 days	90 days
=D2+30	=E2+30	=F2+30
=IF(E2<=NOW(),"true","")	=IF(F2<=NOW(),"true","")	=IF(G2<=NOW(),"true","")

<colgroup><col style="mso-width-source:userset;mso-width-alt:2694; width:120pt" width="160" span="2"> <col style="mso-width-source:userset;mso-width-alt:2344;width:104pt" width="139"> </colgroup><tbody>
</tbody>

So when I enter the date in D2, E2 which is in green 30 days give me 30 days out from that date. If D2 is blank the conditional formatting remains.
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { font-weight: 700; border: 0.5pt solid windowtext; }.xl66 { border: 0.5pt solid windowtext; }</style>

30 days	60 days	90 days
1/30/1900	2/29/1900	3/30/1900
true	true	true

<colgroup><col style="mso-width-source:userset;mso-width-alt:2694; width:60pt" width="80" span="2"> <col style="mso-width-source:userset;mso-width-alt:2344;width:52pt" width="70"> </colgroup><tbody>
</tbody>

This is what I get when E2 is left blank, I would greatly appreciate the help

 

[etaf]

because a blank cell is read as 0 - which is also seen as a date 1900 - thats why you get the formatting as it is lower

use an AND ( E2<>"" , E2 <= now() )

E2 <> ""
is testing if the cell E2 is NOT <> blank

Now() also uses the time off the system
if you are just using a Date and NOT the time use
Today()

you can add the formula direct to conditional formatting and do not need to use a IF with true and false
conditional formatting will only apply if the formula is true

 

[Newbienew]

Thank you so much for you help. I got it to work.

 

[etaf]

you are welcome