Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
Can I change font/color if value is less than another value? | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |