| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reformat to get more hierarchical view
hi,
I'd like to show something like: valA,val10,val11,val21 valA,val10,val11,val22 valA,val10,val12,val58 valA,val10,val13,val59 valB,val90,val91,val92 as: valA , val10 ,val11 ,val21 ,val22 ,val12 ,val58 ,val13 ,val59 valB ,val90 ,val91 ,val92 Is there any easy way to achive it? thanks chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reformat to get more hierarchical view
Alternative suggestion.
Select A2:D5 menu FormatConditional Formatting Change Condition1 to Formula Is Select FormatFont Change Color to white exit -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ciapecki" wrote in message ups.com... hi, I'd like to show something like: valA,val10,val11,val21 valA,val10,val11,val22 valA,val10,val12,val58 valA,val10,val13,val59 valB,val90,val91,val92 as: valA , val10 ,val11 ,val21 ,val22 ,val12 ,val58 ,val13 ,val59 valB ,val90 ,val91 ,val92 Is there any easy way to achive it? thanks chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reformat to get more hierarchical view
On 13 Aug., 14:09, "Bob Phillips" wrote:
Alternative suggestion. Select A2:D5 menu FormatConditional Formatting Change Condition1 to Formula Is Select FormatFont Change Color to white exit Hi Bob, I tried it but it did not do what I wanted. Notice that from 5rows of data I want to get 13rows of data, this conditional formatting formats only the cells, does not add, move etc the cells with values chris |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reformat to get more hierarchical view
No it doesn't, that is why I called it an alternative. It does pick out the
data though IMO. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ciapecki" wrote in message ups.com... On 13 Aug., 14:09, "Bob Phillips" wrote: Alternative suggestion. Select A2:D5 menu FormatConditional Formatting Change Condition1 to Formula Is Select FormatFont Change Color to white exit Hi Bob, I tried it but it did not do what I wanted. Notice that from 5rows of data I want to get 13rows of data, this conditional formatting formats only the cells, does not add, move etc the cells with values chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hierarchical outlining | Excel Worksheet Functions | |||
| Hierarchical outlining | Excel Worksheet Functions | |||
| Nested grouping of hierarchical headings during/after import | Excel Discussion (Misc queries) | |||
| Hierarchical List | Excel Discussion (Misc queries) | |||
| Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
Hybrid Mode
