I am working with a deployment glidepath spreadsheet and need to conditionally format a cell based on the current quarter of the year and a percent threshold. My conditional format should be able to span 17 quarters (q1 2011 through q1 2015).

Q1 2011 SHOULD be green @ 5%, yellow between 3% and 5% and red below 3%, q2 2011 SHOULD be Green @ 10%, yellow between 10% and 6% and red below 6%. I am dealing with data on a seperate worksheet in the same book.

Any help is appreciated.

TIA!