have amortization table, that you input starting date at the top of the form
and it fills in the monthly due dates, based upon the term in years, and
includes interest and principal etc.

i have a helper cell that takes the date as =YEAR(A1)then a copy and paste
so the cell contains actual number rather than formula.

i want to color all the even years in green and the odd in gold, using this
cond format =$XX/2=int($XX/2) and same except < replaces =. (The cond
formatting would apply to the columns 1 thru 19.

using MS Ofc 07
thx