change font color by groups with VBA

N

newbie

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
 
R

RyanH

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change InputTitle and InputMessage in columns from row 2 thru 1000 0
A Huge Conditional Format Challenge.... 2
Select range then copy rows macro 1
Putting named range into sub written by Tom Olgivy DataVal 4
VBA CreateNames (ignores last 5 rows?) 6
Excel formula/macro integrating with font colors? 3
Sort Range by Font Color 1
Private Sub Worksheet_Change doesn't work? 2

Top