conditional formatting

[Guest]

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

 

[T. Valko]

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto Format>Conditional Formatting
Condition 1
Formula Is: =AND(A1<>"",MOD(A1,2)=0)
Set fill color to GREEN

Click the ADD button

Condition 2
Formula Is: =MOD(A1,2)
Set fill color to GOLD
OK out

Biff

 

[Guest]

the conditions 1-3 doesn't seem to be available in xl 2007 as it was in 2003.
this scheme did not seem to work, any other approaches?
thx

 

[T. Valko]

I don't have Excel 2007 but I've read that the number of conditions is
limited only by available memeory.

I don't know the steps in setting condtional formatting in Excel 2007 but
there still should be an option to use a custom formula.

Biff

 

[Guest]

i changed to $a1 and that corrected the problem
you formula is more compact than mine...thanks

 

[T. Valko]

Glad you got it to work. Thanks for the feedback!

Biff