I am working on a project calendar, i.e Weeks v. tasks
As a task is started I want to get the cell relevant to that task and that week to show "Y" and turn RED. I am using the following statement in each cell to do that,
=IF(AND(G8>=$E$21,G8<=$F$21),"Y","") where G8 is the current date, E21 is...