Excel formula to count date backward and color cell

Hello,

I am trying to color cells based on the Excel formula, so if there are two dates, e.g. Jul 1, 2023, and April 1, 2023, the Excel cells will color backward based on the duration selected?
Anyway, can this be done using conditional formatting?

Thanks!

If all dates were real date (formatted as "mmm-yyyy"), you can use Conditionaing formatting, like this:
In D2 (suppose D1="Jan-23", A2 and B2 is start-end date)
Home/Conditional Formating/New Rule/USe a formula...
=AND(D$1>=$A2,D$1<=$B2)
Apply to whole table
P/S: You may actual want START is smaller date (Apr-2023) and END is larger (Jul-2023). Change it!

It seems like there is no reference to the START date (cell A2) any more, and the START date will be END DATE - 2 months?

Formula:

Please Login or Register  to view this content.