change font color by groups with VBA
 

I have 64 rows x 90 columns of hard data, grouped by R1, R2, R3 and R4 in
rows. Below this I have formulated data which I would like to set font color
by groups after the hard data is sorted by any number of results. How can I
change the font color of all the formulated data by their respective groups
with VBA code?

R1 data data data data start low high stdev growth
R2 data data data data start low high stdev growth


--
newwbie

change font color by groups with VBA
 

If you want code to do this you will have to give us more information, such
as what criteria each group has. Is each group exactly 16 rows? Does each
group the same value in a particular Column? etc.

--
Cheers,
Ryan


"newbie" wrote:

I have 64 rows x 90 columns of hard data, grouped by R1, R2, R3 and R4 in
rows. Below this I have formulated data which I would like to set font color
by groups after the hard data is sorted by any number of results. How can I
change the font color of all the formulated data by their respective groups
with VBA code?

R1 data data data data start low high stdev growth
R2 data data data data start low high stdev growth


--
newwbie