Hello all,
I have reached a bit of a stumbling block for something that I am trying to achieve.
I would like to use conditional formatting on a date range.
In my tables I have "Opended Date" this is automatically generated when a user creates a record, I then have "Due back field" again a date field, which is manually populated by the user.
I would like to complete the following:
The reporting needs to be done on the "Due back field"
If date is within 7 Days of now = Green
If date is within 4 Days of now = Orange
If date is within 2 days of now = Red
I tried to write this is code format but unable to get it right. :banghead::banghead:
The conditional formatting is on a form..
I have reached a bit of a stumbling block for something that I am trying to achieve.
I would like to use conditional formatting on a date range.
In my tables I have "Opended Date" this is automatically generated when a user creates a record, I then have "Due back field" again a date field, which is manually populated by the user.
I would like to complete the following:
The reporting needs to be done on the "Due back field"
If date is within 7 Days of now = Green
If date is within 4 Days of now = Orange
If date is within 2 days of now = Red
I tried to write this is code format but unable to get it right. :banghead::banghead:
The conditional formatting is on a form..
Last edited: