I track our magazines’ copy flow. Columns D and E are tied to each individual magazine’s tab. Every article for the month is listed on its individual magazine’s tab. As those files arrive, we put a link in a separate column. That automatically updates the “Pub Info” page’s  Columns D and E, and the % filed to copy also is automatic.

Right now we have to individually go into each magazine’s 50% and 100% deadline cells on the Pub Info page and make them red or green, depending on whether they met those % by deadline.

Is there a way to have Columns G and H automatically turn each cell red or green on their due dates, depending on whether they made their 50% or 100% deadline (based on Column F)?

Thanks in advance!

​I track our magazines’ copy flow. Columns D and E are tied to each individual magazine’s tab. Every article for the month is listed on its individual magazine’s tab. As those files arrive, we put a link in a separate column. That automatically updates the “Pub Info” page’s  Columns D and E, and the % filed to copy also is automatic. Right now we have to individually go into each magazine’s 50% and 100% deadline cells on the Pub Info page and make them red or green, depending on whether they met those % by deadline. Is there a way to have Columns G and H automatically turn each cell red or green on their due dates, depending on whether they made their 50% or 100% deadline (based on Column F)? Thanks in advance!  Read More

​