Forum Discussion
Excel table styles
Is it possable to have a single table with multiple styles
I have a large table but I would like to group certain sections differently
Kind regards tim
5 Replies
tim_p70f9 Choose a fairly neutral style and than just columns/sections to you liking, as shown in the attached example.
Yes. Are you talking of "styles" as in different fonts, different colors? What do you actually mean?
Anyway, go ahead and try it. You can't break anything by just experimenting.
Upload a sample of your file if you want more specific help, but this is the kind of thing where doing it yourself (to the extent you're able) is a better way to learn.
hi sorry so currently the sheet is arranged into single table with groups of subtasks that take up approximately 3-6 rows my hope was for a relatively easy way soapily different colours to these sections e.g the first section is alternate row colour dark blue light blue the next section dark grey light grey alternating through the sheet also there is approximately 1000 row so I didn't really fancy doing this manually
I can't put up a example till I'm back home tommorow
kind regards tim
There is "conditional formatting" capability, which might apply. The trick there is that there would need to be a "condition" defined. So a question: are the subtasks you mention identified with some field that makes any given grouping of cells uniquely identifiable? If so, you could use conditional formatting.
A lot depends here on how simple you're willing to be. If you just want to be clear on where each group of subtasks begins and ends, you could write a simple formula that assigns a letter code and just cycle through three or four codes. That way you could write conditional formatting rules such that all coded A could be with green background, B with yellow, C with pink....etc.
Is it safe to assume that once pointed in the right direction you'd like to figure out how to do it yourself? I'd be happy to work with your example file after you post it; but you've come this far on your own and might want to finish it off.
