conditional formatting
 

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

conditional formatting
 

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto FormatConditional 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

"reno" wrote in message
...
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

conditional formatting
 

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" wrote:

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto FormatConditional 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

"reno" wrote in message
...
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

conditional formatting
 

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

"reno" wrote in message
...
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" wrote:

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto FormatConditional 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

"reno" wrote in message
...
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

conditional formatting
 

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

"T. Valko" wrote:

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

"reno" wrote in message
...
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" wrote:

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto FormatConditional 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

"reno" wrote in message
...
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

conditional formatting
 

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

Biff

"reno" wrote in message
...
i changed to $a1 and that corrected the problem
you formula is more compact than mine...thanks

"T. Valko" wrote:

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

"reno" wrote in message
...
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" wrote:

Try this:

Assume the range in question is A1:A5
Select the range A1:A5
Goto FormatConditional 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

"reno" wrote in message
...
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