| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
