I putting together a tracking chart, but this particular scenario is twisting my mind. I will greatly appreciate any help. I have created multiple conditional formats on a cell based a period of dates; additionally, I would like to keep the active color-conditional format for a cell after its specific deadline. For example, cell B1 has todays date, cell B2 has conditional formats to change color based on three levels of a cell A2 (green=completed, yellow=in progress, red=not started) for all previous days until today as indicated by the date on cell B1. So now I want to programm cell B2 to keep the color format that is active on the date indicated on cell B1 after the date has passed?