Forum Discussion
Need help with a date formula on Excel
To do that, please select the whole column D by clicking on the column letter D and make New Rules for conditional formatting using the formulas given below...
For Green (0-180 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=0,J1-TODAY()<=180)For Yellow (181-270 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=181,J1-TODAY()<=270)For Red (271-364 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=271,J1-TODAY()<=364)For Black (365+ days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=365)Please find the attached with the conditional formatting in place for all the colors.
To do that, please select the whole column D by clicking on the column letter D and make New Rules for conditional formatting using the formulas given below...
For Green (0-180 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=0,J1-TODAY()<=180)
For Yellow (181-270 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=181,J1-TODAY()<=270)
For Red (271-364 days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=271,J1-TODAY()<=364)
For Black (365+ days):
=AND(ROW()>1,ISNUMBER(J1),J1-TODAY()>=365)
Please find the attached with the conditional formatting in place for all the colors.
You're welcome salvadominican! Glad it helped.
If that resolved your issue, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.