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

Putting named range into sub written by Tom Olgivy DataVal 3
add rows with copy format of previous row 2
Lookup and Enter Value to Other Tab on Change in Cell 0
AutoFiltering with Grouped Data 3
Excel formula/macro integrating with font colors? 3
Sort Range by Font Color 1
Interior and font color change based on value 6
Macro to delete row based on criteria (first few characters of string) 5

Top