Conditional Format for the future Periods
I have a query related to dashboard, I have a line item called "Potential Retirement Date" in date format.
1. Whenever the date/year is 2019(current year) + 2 years(till 2021) it should show Orange color.
2. Whenever the date/year is 2018(Previous Year) is should show Red color.
3. Whenever the date/year is more than 2 years of current year i.e. from 2022 it should show no color.
I have done with the above 1 & 2 points, but in 1st point it is working fine to 2019 + 1 year and not +2 years, cuz in the model calendar the number of future years is 1. so it is working fine.
It is working fine for the previous years as no of past years is 2.
So Could someone help me with the solution.