should I use conditional format or something else

[rgazzara]

Good morning,
I am using excel 2007 and I have a report that maintains when an inspection was last completed in the format of quarters and the year completed (32011=quarter 3 year 2011) . I have tried to set conditonal formatting to show that all previous quarters from the current quarter and year are red, the next 2 quarters are yellow, and 3 or more quarters out are green,but I've ran into some difficulty with the formula. Please see below for a example of the cells. If the current quater is 32011, then 42011 would be yellow (next quarter), 32012 would be green (greater then 2 quarters) and the 32010 would be read (past current quarter). I have dates ranging from 12006 to 42014. Can I use conditonal format or do I need use maybe something else (macro, VBE) to find another way to complete what I need done. Any help on this would be greatly appreciated.

V/R
Rob Gazzara <!-- / message -->

NEXT MI
<TABLE style="WIDTH: 35pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=46 border=0><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 35pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=46 height=17>
42011


</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 35pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=46 height=17>32012 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 35pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=46 height=17>32010 </TD></TR></TBODY></TABLE>

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=566281

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).