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>
<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>
<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
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>