S
ScrappinCntry
I am looking for the a macro formula, or an excel formula...
I have an AR Aging report which is very complex. It is broke into 2
sections within the same sheet. The 1st section is grouped by type of
customer and the 2nd section is actually aging the amount due. The 2nd
section is font-colored coded according to aging (green font is 1-30, yellow
font is 31-60, 61-90 and red font for 91+.
Is it possible to make a macro to change the font of section 1 to reflect
the same color of font in section 2? Now as a twist, section 1 is formulated
to look at the group, the balance and place it in a cell according to cell
titles.
For example, =IF($F2=$C4,$E4,0) - F2 is column title, C4 is cell group
title, E4 is the amount from sec 2 aging balance.
Any assistance would be appreciated. Thanks!
~Dawne
I have an AR Aging report which is very complex. It is broke into 2
sections within the same sheet. The 1st section is grouped by type of
customer and the 2nd section is actually aging the amount due. The 2nd
section is font-colored coded according to aging (green font is 1-30, yellow
font is 31-60, 61-90 and red font for 91+.
Is it possible to make a macro to change the font of section 1 to reflect
the same color of font in section 2? Now as a twist, section 1 is formulated
to look at the group, the balance and place it in a cell according to cell
titles.
For example, =IF($F2=$C4,$E4,0) - F2 is column title, C4 is cell group
title, E4 is the amount from sec 2 aging balance.
Any assistance would be appreciated. Thanks!
~Dawne