Hello,
I Need to set a conditional formatting.
Scenario:
After I enter the filing date then the 270 and 360 date return will appear.
Let say that I am working the calendar date of 2/28/22.
Under the 270 date return 2/6/22, then this will be “ELIGIBLE” because before the calendar date.
Then, under the 360 days is “NOT ELIGIBLE” because it is not after the date return 05/07/22.
So it’s actually from the calendar date to set a conditional formatting. If the date return is before the calendar date then “ELIGIBLE” and the calendar before the date return then it’s “NOT ELIGIBLE”.
Color blue “ELIGIBLE” and color red “NOT ELIGIBLE”.
Bookmarks