Forum Discussion
Excel table styles
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.
- That’s both some really good ideas I shall have a play about
Many thanks tim